numeric conversion

  • Thread starter Thread starter Angie Kelly
  • Start date Start date
A

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
 
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
 
Back
Top