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.ht

--
VBA Noo
-----------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...fo&userid=3383
View this thread: http://www.excelforum.com/showthread.php?threadid=56124

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" <(E-Mail Removed)> wrote in message
news:1F114B29-11B6-4534-BCAD-(E-Mail Removed)...
>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?