Home |
Search |
Today's Posts |
#1
|
|||
|
|||
elapsed time calculation
I am preparing a worksheet which calculates the length of a telephone cal
from one time to another. I have a formula, which will calculate the elapsed time in the form h:mm:ss. I also need to add the total elapsed time of many calls with the goal of expressing the answer as minutes and tenths of minutes, for example the total may be 3,478.4 minutes. Any ideas how I can calculate elapsed time expressed as minutes and tenths of minutes rather that h:mm:ss? -- rwf |
#2
|
|||
|
|||
To get decimal minutes use =SUM(Range)*1440
or perhaps =ROUND(SUM(Range)*1440,2) and format as general -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "rwf" wrote in message ... I am preparing a worksheet which calculates the length of a telephone cal from one time to another. I have a formula, which will calculate the elapsed time in the form h:mm:ss. I also need to add the total elapsed time of many calls with the goal of expressing the answer as minutes and tenths of minutes, for example the total may be 3,478.4 minutes. Any ideas how I can calculate elapsed time expressed as minutes and tenths of minutes rather that h:mm:ss? -- rwf |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Manual calculation" takes less time. Why? | Excel Discussion (Misc queries) | |||
Elapsed time Calc...over 30 days long... | Excel Discussion (Misc queries) | |||
Elapsed time Calc...over 30 days long... | Excel Discussion (Misc queries) | |||
Elapsed time Calc...over 30 days long... | Excel Discussion (Misc queries) | |||
Excel - Time calculation | Excel Discussion (Misc queries) |