Home |
Search |
Today's Posts |
#1
|
|||
|
|||
time formula
Hi all,
(office 97) You guys helped me the other day with some formula where I wanted to convert say a figure of 93 into seconds. This was done & works fine, the formula was as follows; In cell A2 enter =INT(A1/60) + MOD(A1,60)/100 I now need help changing the format slightly. Say for example there was a figure of 3666, I need to make the formula diaplay as 01:01:06 ie 1 hour, 1 min & 6 secs Have set the cell format to the above. If you have any ideas it would be appreciated as I am out of my depth Thanks again in advance |
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) | |||
need help with time formula | Excel Worksheet Functions | |||
Time / Formula to look at time difference | Excel Worksheet Functions |