I am trying to calulate total time

[Guest]

I am working on a spreadshett to calulate my total hours worked. How can I
add this together? I have tried to just add the time with the SUM feature, I
have tried to add each item individually...However, the program is adding
these like they are actually times during the day and not total hours worked
each day. I am trying to find the total hours worked in the HH:MM format...I
should get a total somewhere around 30:52 but I am getting 6:57 as an answer.
How do I fix this?

 

[VBA Noob]

Hi,

Try formatting cell as [h]:mm

See attached for full details

http://www.j-walk.com/ss/excel/usertips/tip064.ht

 

[Biff]

Try using this format:

[hh]:mm

If the total was supposed to be 25:00, then using this format hh:mm, the
result would be 01:00 Using [hh]:mm, the brackets keep the hours from
rolling over and the result would be 25:00.

Biff

 

[Guest]

Format (SUM) cell as [h]:mm

HTH