numbers to time

J

Jibba02

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
 
Top