The largest time value that can be *manually* entered in a cell is
9999:59:59.

You can use formulas to return much higher time values, though. So, you'd
need to split your time into 2 cells:

A1 = 5000:00
A2 = 5000:00
A3 = 3:53

=SUM(A1:A3)

Returns 10003:53

--
Biff
Microsoft Excel MVP


"Alan" wrote in message
...
when adding a hour number larger that 10,000 to another time number the
formula will not give a correct answer. Tried several time formats and
nothing worked. I need a format that is (HH,HHH:MM).