Adding Hours & Minutes

  • Thread starter Thread starter Tina
  • Start date Start date
T

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
 
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?
 
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:
Click to expand...
Submitted via EggHeadCafe
Creating Google Motion Charts from Excel data
http://www.eggheadcafe.com/tutorial...ing-google-motion-charts-from-excel-data.aspx
Click to expand...
Click to expand...
 
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.
Click to expand...

Try Custom Formatting the cells using this...

[h]:mm

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