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