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

R

Ronnie Kray

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
 
T

T. Valko

I don't know which of the other formulas you used but this one will (should)
work:

=SUM(A3:B3)

Format as [h]:mm
 
Top