View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default Converting a decimal number into time

How does 111.8 relate to :71.80 and 123.8 to :83.80 ?

How about:
1 minute 11.8 seconds = 71.80 seconds
1 minute 23.8 seconds = 83.80 seconds


Ah, very sharp!

Biff

"David Biddulph" wrote in message
...
"Biff" wrote in message
...
Hold on there a second (no pun intended)!


22.4
46.6
111.8
123.8
Need to convert to [ss].00:
:22.40
:46.60
:71.80
:83.80


How does 111.8 relate to :71.80 and 123.8 to :83.80 ?

Biff


How about:
1 minute 11.8 seconds = 71.80 seconds
1 minute 23.8 seconds = 83.80 seconds
--
David Biddulph