If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|