Krishna,

Now, is this mentioned anywhere in the online help?

Sure. Search for

Number format codes

HTH,
Bernie
MS Excel MVP


Yes! That works. For the previous set of numbers I gave, the result does
come
out as 31:45, as it should.


Thank you very much.



"Bernie Deitrick" wrote:
Format your cell for
[h]:mm:ss