0-60 minute time format

  • Thread starter Thread starter Drew Remsen
  • Start date Start date
D

Drew Remsen

I have a data string of numbers between 0-59 that are part of a time
signal collected by an instrument that correspond to the minute of the
time signal. For values between 0-9 I would like them instead to read
like 00-09. The rest of the digits are already in a two digit format so
they are fine.How can I accomplish this?
Andrew
 
-------------------------------------------------------------------------
Format the cells by
Format > Cells... > Custom>

In the "Type:" field enter the following format and this should do
the trick

"00:"00

and click OK

Thanks
KB
-------------------------------------------------------------------------
 
Back
Top