Hour Totals

[runner]

When I reach a total hours over 9999:00:00 the sum will not add up. How can
this be fixed.

 

[David Biddulph]

When I add 9000:00:0 to 7000:00:00, I get 16000:00:00
What is your difficulty?

 

[Fred Smith]

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.

 

[Joel]

=24*INT(SUM(A20+A21))+HOUR(SUM(A20+A21))&":"&TEXT(MINUTE(SUM(A20+A21)),"#00")