Greetings,

I am building a simplified timesheet with the time portion looking like
this:

Shift Start Shift End Time Worked
14:45 23:30 8.8
17:00 0:00 7.0
12:45 17:00 4.3
0:00 0:30 0.5
6:45 10:15 3.5
15:15 23:30 8.3
7:00 9:00 2.0
18:15 0:00 5.8
0:00 6:30 6.5
7:15 17:30 10.3

The first 2 columns are formatted as time 13:30 and the last column is
formatted as number 1 decimal place.

The formula I use to obtain the hours worked is straightforward
(ShiftEnd-ShiftStart)*24.

When I try and use the sum function to sum up the total time worked per
week I get 56.8 whereas the correct answer is 57. When I just copy the
numbers manually to another column and sum them up, I get the correct
answer. I have a feeling the problem has something to do with the way
Excel stores time but I can't figure it out. Any help appreciated.

Thanks
M. Tovbin