Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |