| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate average given minutes and seconds
I'm trying to calculate the average minutes and seconds for a given task. We
have 4 sets of minutes and seconds. I want the minutes and seconds to display as mm:ss but when I select this as a format it seems to round off to nearest minute. I want the resulting average to display as mm:ss also. Can someone please tell me the correct format to use in Excel 2007 to get mm:ss and also the formula to calculate the average. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I calculate times in seconds and minutes using percentages | Excel Worksheet Functions | |||
| Average time for a race in minutes seconds & tenths | Excel Worksheet Functions | |||
| HOW TO CALCULATE HOURS WITH MINUTES AND SECONDS? | Excel Discussion (Misc queries) | |||
| Formatting minutes and seconds to calculate a total average | Excel Worksheet Functions | |||
| calculate average hours and minutes | Excel Worksheet Functions | |||
Threaded Mode
