I have a worksheet where I am having a time in and time ut calculated to
hours owrked for a week. At the end I need to add the total hours of each
day for a weekly total. I have everythig working except the adding od the
week, whihc is not giving me the correct answers. I have checked the
formatting of all the cells, and followed the guides available in excel
help, but cannot get it to work. The odd this is when I just add two days
(i.e. Monday and Tuesday) it works fine. Only fouls up when I add the third
day to it.

example format:

Semester 1 Monday Tuesday Wednesday Thursday Friday Total Hrs
Week Of: In Out Hrs In Out Hrs In Out Hrs In Out Hrs In Out Hrs
8/8/2005 8:32 17:05 8:33 8:10 17:32 9:22 8:15 16:25 8:10 8:00 16:00
8:00 8:12 13:00 4:48 14:53


Thanks in advance

--


John C. Harris, MPA
JCZ Consulting Services, LLC