Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average time
I have a list of mm:ss times in a column. I want to find the average of the
list. I have tried different things, but I keep getting 'Divide by zero error' (#DIV/0!) How do I fix this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average time
Should work..The error is returned because there are no numerics in the
range...Check whether the time is stored as text. What is the cell format. Try typing minutes seconds to another column or new workbook and try averaging.. To convert these values to numerics; copy a blank cell and select the range and PasteSpecialselect 'Add' and OK.. -- Jacob (MVP - Excel) "DSN" wrote: I have a list of mm:ss times in a column. I want to find the average of the list. I have tried different things, but I keep getting 'Divide by zero error' (#DIV/0!) How do I fix this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average time | Excel Worksheet Functions | |||
Average of Day and Time | Excel Worksheet Functions | |||
Average Time | Excel Worksheet Functions | |||
average rate of change per given time period between 2 moments in time of a value | Excel Worksheet Functions | |||
Average Time | Excel Worksheet Functions |