time sum incorrect
When you sum up the decimals in Column 3, you get 57. Even if you sum
up just the fractional part, you get a 0.
Best Regards
Bob Phillips wrote:
What makes you think it should be 57? I get 56.75, which rounds to 56.8 to 1
decimal place.
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"mtovbin" wrote in message
oups.com...
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
|