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?

Hi,

Try formatting cell as [h]:mm

See attached for full details

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561247

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

"Karl" wrote in message
...
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?

Format (SUM) cell as [h]:mm

HTH

"Karl" wrote:

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?