| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My Quest with Time!! | Excel Worksheet Functions | |||
| Adding time | Excel Discussion (Misc queries) | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| Time Sheets | Excel Discussion (Misc queries) | |||
| unmet challenge | Excel Worksheet Functions | |||
Linear Mode
