total Hours Worked for week PS thx for the formulars everyone!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Mon Tue
A1 B1
7:00 7:00 Start Time

A2 B2
17:00 16:45 Finish Time

A3 B3
10:00 9:45 Total Hours worked

How do i add A3 & B3 to show 19 Hours & 45 Mins
 
I don't know which of the other formulas you used but this one will (should)
work:

=SUM(A3:B3)

Format as [h]:mm
 
Back
Top