I process documents and want to get a formula showing the average time to process each document.
Here's my data:
- number of docs processed (column G)
- start date/time (H)
- end date/time (I)
- elapsed time (J)
A simple average formula in the corresponding chart is yielding a
The time format I'm using in column J is:
=DATEDIF(H3,I3,"d") & " Days " &TEXT(I3-H3, "h:m" )& " hrs:min"
I'd like to get the average time spent on each document in my chart.