| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting minutes and seconds to calculate a total average
Please help. I am entering minutes and seconds...i.e. 34:10 into a
worksheet to be charted. One column is number of calls, the other column is minutes and seconds. At the bottom of the column I need an AVERAGE of the total minutes and seconds. I've tried to format the cells for mm:ss but it seems to convert the time to hh;mm;ss? Any suggestions.....Please help I'm going crazy trying to figure this out. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum minutes and seconds to total hours | Excel Discussion (Misc queries) | |||
| Formatting Time with Hundredths of Seconds | Excel Worksheet Functions | |||
| Create a custom format to convert seconds to minutes. | Excel Discussion (Misc queries) | |||
| Formatting Hours and Minutes | Excel Discussion (Misc queries) | |||
| convert seconds to minutes and seconds | Excel Worksheet Functions | |||
Threaded Mode
