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 |