Adding Hours & Minutes

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
 
L

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

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
 
R

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top