Thread: numbers to time
View Single Post
  #1   Report Post  
Jibba02
 
Posts: n/a
Default numbers to time

how do i convert numbers into time format

eg. i would like to convert a number from cell 1B into time format in cell
1A.
so if i typed 90 into 1B it would automaticly display 0.01.30.
90seconds equals 1minute and 30 seconds


Cheers
Tim