View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M.A.Tyler
 
Posts: n/a
Default Converting a decimal number into time

Would like to convert a decimal number into time. Data is supplied as follows:
22.4
46.6
111.8
123.8
Need to convert to [ss].00:
:22.40
:46.60
:71.80
:83.80
Is there a formula I can use for this conversion?

Thanks in advance!