Hi!

Format the cell as h.mm.ss

Then enter this formula:

=B1/86400

Biff

"Jibba02" wrote in message
...
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