All I did was keep you looking <g

Bob

"John C. Harris, MPA" wrote in message
...
I got it working. I cleared everything and re-entered formatting and it
worked. Must have been something hiding in there. Thanks for the help.

--
John C. Harris, MPA
JCZ Consulting Services, LLC
"Bob Phillips" wrote in message
...
That just proves that it has the correct calculation. Therefore, [hh]:mm
should work.

I have just duplicated your data and I get 38:53 with that format.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John C. Harris, MPA" wrote in message
...
I sure did. That's why it is confusing me. Van't figure out why it is
not
working.

Another thing I found though: If I take the Sum formula =SUM(A1, B1,
C1)
and
multiply it by 24, =SUM(A1, B1, C1)*24, and change the cell format to a
number, I get the correct hours in decimal format (i.e. 44:33 changes
to
44.6).

--
John C. Harris, MPA
JCZ Consulting Services, LLC
"John C. Harris, MPA" wrote in message
...
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