Forum Discussion
Calculating average days, hours, minutes excluding weekend and holiday
Hi all, I have start time on Column A and end time on column E in yyyy-mm-dd h:mm format and I calculate the time difference between the two on Column G using formula =$E6-$A6 in d "days," h "hours,...
Not sure I catch the question. Format doesn't matter, it only defines how to show values to users. You may take average of such values and display it in any applicable format you wish.
I add more info on my post, hopefully it helps.
So, there are multiple entries and I tried to get the average of the time difference using the same d "days," h "hours," m "minutes" format. I tried using Average formula but it didn't works.