Adding Hours & Minutes

[Tina]

I am adding a large column of hours and need a total for the end of the
month.

0:00
0:00 5
0:00
0:00
0:00
0:00
0:00
0:00 5
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
00:00
I have formulas in the cells above to calculate the number of hours when an
employee enters their time.

I can't get it to give me a correct value of the hours and minutes. This is
what my formula looks like: =SUM(E12:E37)

The cell is formatted to this: [hh]:mm

 

[Luke M]

Everything looks correct. What is your formula returning? Is it returning a
zero, or just some number that doesn't agree with what you think it should be?

Possible problems:
Are your formulas, for some reason, returning a text value thus causing SUM
to = 0?

What are the floating 5's in your example for?

 

[D]

I having the same problem as above in Excel with adding hours in a column. When it reaches 24 hours accumulated, it drops the hour and only displays the minutes. Cannot find resolution in the help.

Thanks.
D

I am adding a large column of hours and need a total for the end of the
month.

0:00
0:00 5
0:00
0:00
0:00
0:00
0:00
0:00 5
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
00:00
I have formulas in the cells above to calculate the number of hours when an
employee enters their time.

I cannot get it to give me a correct value of the hours and minutes. This is
what my formula looks like: =SUM(E12:E37)

The cell is formatted to this: [hh]:mm

On Friday, September 18, 2009 12:48 PM Luke M wrote:
Everything looks correct. What is your formula returning? Is it returning a
zero, or just some number that does not agree with what you think it should be?

Possible problems:
Are your formulas, for some reason, returning a text value thus causing SUM
to = 0?

What are the floating 5's in your example for?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tina" wrote:

Submitted via EggHeadCafe
Creating Google Motion Charts from Excel data
http://www.eggheadcafe.com/tutorial...ing-google-motion-charts-from-excel-data.aspx

 

[Rick Rothstein]

I having the same problem as above in Excel with adding hours

in a column. When it reaches 24 hours accumulated, it drops
the hour and only displays the minutes.

Try Custom Formatting the cells using this...

[h]:mm

as your format pattern (note the square brackets surrounding the h)