| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Thats wrong, please ignore,
Apologies, Alan. "Alan" wrote in message ... Try formatting as 'Custom' [hh]:mm:ss Enter the time elapsed as 15:30 or 68:25 etc, Regards, Alan. "VeronicaO" wrote in message ... 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
