numeric conversion

[Angie Kelly]

hi there

i need to represent numbers as minutes and seconds - as a
duration rather than a representation of time.
any help would be appreciated......

thanks
angie

 

[Bernie Deitrick]

Angie,

If you enter 00:15:30 for 15 minutes and 30 seconds, then you get just that,
and can do all the necessary math.

Alternatively, enter 15 in cell A1, and 30 in cell B1, and in C1 use the
formula:
=TIME(0,A1,B1)

and formatted for the third time format, or 13:30:55 (I really never
understood why Excel doesn't show hh:mm:ss as the time formats.....)

HTH,
Bernie
MS Excel MVP