I have a spreadsheet that adds time, orning session, afternoon session. I
then sum the time for the day. All of that works great, but when I try to
add the week together, from the sums, the calculation is incorrect, it gives
me a number like 17.234455..

Any ideas what I'm doing wrong?

I tried this and had no problem.

I assume you've checked your formatting to ensure that all cells have
the appropriate format for time?


--
jonhunt
------------------------------------------------------------------------
jonhunt's Profile: http://www.excelforum.com/member.php...o&userid=35370
View this thread: http://www.excelforum.com/showthread...hreadid=566654

Maybe, because it's a sum of a sum, it's not working

Day Date Start End Time Work Start End Time Work Reported time
Mon 07/24/20068:15 AM 12:00 3:45 12:30 5:15 PM 4:45 8:30
Tue 07/25/20068:00 AM 12:00 4:00 12:30 4:30 PM 4:00 8:00
Wed 07/26/20067:45 AM 12:00 4:15 12:30 4:45 PM 4:15 8:30
Thu 07/27/20067:45 AM 12:00 4:15 12:30 5:00 PM 4:30 8:45
Fri 07/28/20067:30 AM 11:30 4:00 12:00 4:00 PM 4:00 8:00
Total 20:15 21:30 *17:45


"jonhunt" wrote:


I tried this and had no problem.

I assume you've checked your formatting to ensure that all cells have
the appropriate format for time?


--
jonhunt
------------------------------------------------------------------------
jonhunt's Profile: http://www.excelforum.com/member.php...o&userid=35370
View this thread: http://www.excelforum.com/showthread...hreadid=566654

I put your data in a spreadsheet and had no problems.

I'm usually here asking for help instead of giving it, but if you want
to give me an email address I can send you the spreadsheet I worked in
and see if you can spot the differences. There apparently is a way here
to send a private message, but I'm not famliar with that...I just see
that notice when I log in.

Jon


--
jonhunt
------------------------------------------------------------------------
jonhunt's Profile: http://www.excelforum.com/member.php...o&userid=35370
View this thread: http://www.excelforum.com/showthread...hreadid=566654