Hi
are all hours for a day formated as time?

--
Regards
Frank Kabel
Frankfurt, Germany

wssparky wrote:
Hi,
I've got the same problem and I don't get it.
I have a time sheet with 7 days , Clock In and Clock Out
Subtract the two and get the hours for the day. That part works.
But when I add them I get a strange number.
I have the cell formatted like you said [hh]:mm

Here are the Hours for the day
mon 10:00
tue 9:17
wed 12:00

I know the total is 31.17
Excel says its 24.00

WHY DO IT BE THIS WAY! AHHHH!


wssparky
I'm a product of public schools so go slow.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!