| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Time formula
Team,
(Office 97) Can you tell me how to...... A cell contains a number say 93 - This cell represents seconds & I want to be able to make a formula that will covert that number to 1.33 ie 1 minute & 33 seconds. Can this be done? I have been playing around & cannot see anything obvious. I appreciate your help in advance James |
|
#2
|
|||
|
|||
|
One way:
A1: 93 A2: =INT(A1/60) + MOD(A1,60)/100 In article , "James" wrote: Can you tell me how to...... A cell contains a number say 93 - This cell represents seconds & I want to be able to make a formula that will covert that number to 1.33 ie 1 minute & 33 seconds. Can this be done? I have been playing around & cannot see anything obvious. I appreciate your help in advance |
|
#3
|
|||
|
|||
|
Thankyou very much - formula worked fine
"JE McGimpsey" wrote: One way: A1: 93 A2: =INT(A1/60) + MOD(A1,60)/100 In article , "James" wrote: Can you tell me how to...... A cell contains a number say 93 - This cell represents seconds & I want to be able to make a formula that will covert that number to 1.33 ie 1 minute & 33 seconds. Can this be done? I have been playing around & cannot see anything obvious. I appreciate your help in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for averaging times | Excel Discussion (Misc queries) | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
| Formula for time? | Excel Discussion (Misc queries) | |||
| Time / Formula to look at time difference | Excel Worksheet Functions | |||
| Excel Time Duration Formula | Excel Worksheet Functions | |||
Linear Mode
