ExcelBanter - numbers to time

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - numbers to time (https://www.excelbanter.com/excel-worksheet-functions/53272-numbers-time.html)

Jibba02

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

Biff

numbers to time

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

Jibba02

numbers to time

Ahh got it.
Thanks heaps

Tim

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

All times are GMT +1. The time now is 11:27 PM.