Excel time formatting

New Contributor

I have an excel file
which is in one of the columns of that time
In this case, I cannot get the average from it, and I have double click on each cell twice to be able to get the average from them.
Please advise



2 Replies


The #DIV0! means that there are no numbers within the list, only text.  You can either recommit the text, as you are doing or by using 'text to columns', or use formulas to force Excel to coerce the text to numbers.  Techniques include the function VALUE or TIMEVALUE or preceding the reference by a double unary minus "--".

thanks a lot
I appreciate the solution you gave me