Timesheet

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

A B C
1 Start Time End Time Hours
2 18:00 22:00 04:00
3 22:00 08:00 10:00
4 17:00 23:00 06:00
5 16:00 21:00 05:00
6 18:00 23:00 05:00
7 Total Hours 06:00

Please can anyone help with the above problem. In row 3
because the end time is the following day I had to add 24
to get the correct hours.But this caused the problem when
adding the total hours in C7. Many thanks
 
Hi
in C2 put
=B1-A1+(B1<A1)
copy down

in C7 put
=SUM(C2:C6)
and format this cell with the custom format:
[hh]:mm
 
Back
Top