Ah, yes. I remember this problem.

I found earlier that this was a problem, that it was an Excel oddity. I
found that as long as you keep below 10000
for the base number, you can continue adding it without problem.

This may not be ideal, but if you use something like a running total, it
should work. The trick is never to try adding a cell that is greater than
10000. As long as they arev all below, it adds and shows okay.


--

HTH

RP

"BPHMA" wrote in message
...
Bob,
I am using [hh]:mm. This works fine until I get to 10,000 hours, then
when I try to Sum cell a1 and a2 it doesn't work.

"Bob Phillips" wrote:

A|re you storing the values of time and finding it can only go as far as
24?
If so, format the cell as [h]:mm

--

HTH

RP

"BPHMA" wrote in message
...
I am trying to keep track of the hours and minutes a machine has
operated.
This can get up to 20,000 hours. How do I add daily operating hours
to
the
begining total?