Forum Discussion
average in duration of time
How do I take an average of a time duration. Every time I use the average formula it gives me an error message. For example elapsed time of 1:31, 2:14, 3:23 and 0:34. What formula would I use to get ...
Are the values in N4:N304 entered manually or are they the result of formulas? If the latter, what do these formulas look like?
They were exported from a report that I ran. They came out in a general format under the number tab. HansVogelaar
Select N4:N304.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Finish.
Does the formula work now?
- Yes it finally works, thank you very much for your help with this.
