| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average for times using minutes and seconds
Hi,
We need a formula to average out times in minutes and seconds (not AM/PM), example B3 has 3.51, C3 has 3.42, D3 has 3.37 and E3 has 3.57 (formats for these cells are just Number as using the Time format results in these times being converted to AM/PM). Can anyone help, as using just an Average formula results in results that are above 60 seconds. Thanks, Adrian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate average given minutes and seconds | Excel Discussion (Misc queries) | |||
| 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 | |||
| Formatting minutes and seconds to calculate a total average | Excel Worksheet Functions | |||
| How do I enter minutes and seconds (lap times)? | Excel Discussion (Misc queries) | |||
Threaded Mode
