I have an Excel 2007 worksheet where I need to calculate the difference between 2 times, excluding weekends, then at the end of a week or month, be able to find the average of the amounts of time in the 'difference' column.
Here's what I have so far:
=NETWORKDAYS(A3,H3)-1&" DAYS, "&TEXT(H3-A3,"HH"" HRS AND ""MM""MIN"""))
Which gives me a result of 1 DAYS, 02 HRS AND 03MIN which is fine; I just can't figure out a way to find an average of the data in that column with the time expressed in this format.
Any suggestions?
Thanks much.