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).

Unfortunately 10,000 hours is an Excel limit, you have to find a workaround
for handling greater number of hours (e.g. work with plain numbers).

Regards,
Stefi

€žAlan€� ezt Ã*rta:

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).

As Stefi mentioned, you've run into a type of limit. XL doesn't recognize
"10000:15" as being a time value. However, you can do the mathematical
equivalent of

="3:00"+10000/24+15/(24*60)

with the middle term being your hours and last term being minutes.To get the
format you desire, you'll have to *fake* it, and use a formula similar to:

=TEXT(INT(A2*24),"#,###")&":"&MINUTE(A2)
where A2 is the cell containing previous formula.

the problem with this is you now have a text string as opposed to a number.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Alan" wrote:

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).

Add it in two stages, 5000 and then another 5000.

--
__________________________________
HTH

Bob

"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).

Even in ne formula it works

=K2+"5000:00:00"+"5000:00:00"

--
__________________________________
HTH

Bob

"Bob Phillips" wrote in message
...
Add it in two stages, 5000 and then another 5000.

--
__________________________________
HTH

Bob

"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).

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).