Hour Totals

  • Thread starter Thread starter runner
  • Start date Start date
R

runner

When I reach a total hours over 9999:00:00 the sum will not add up. How can
this be fixed.
 
When I add 9000:00:0 to 7000:00:00, I get 16000:00:00
What is your difficulty?
 
They add up for me. I can display a sum of 10000:00:00. Give us more
information on what you are doing.

Another option may be to eschew times, and just enter your hours as numbers
with whatever precision you want (ie, 1 or more decimal places). You'll have
more control over the formatting then.

Regards,
Fred.
 
=24*INT(SUM(A20+A21))+HOUR(SUM(A20+A21))&":"&TEXT(MINUTE(SUM(A20+A21)),"#00")
 
You must log in or register to reply here.

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

Similar Threads

Sum hours 1
Adding time in hours 2
Subtraction formula with Text error 7
Calculating Times for Pay Rates 4
Adding Time in Excel - Frustating experience!! 5
counting hours 1
How do I calculate time in excel (clock in and clock out 3
Summing hours and munites 2

Back
Top