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
|