I'm new to the forum and relatively new to functions/formulas in Excel. With that said, I need some help creating the correct
formula in Excel. I am trying to find the number of hours between two dates excluding weekends (Saturday & Sunday). The
point of the calculation is to count the number of work orders that were resolved in less than 2 working days or 4 working
days, so I have been using a 24 hour clock for the formulas I was working with.
I have searched the forum and
this is the closest thread I have found, but the numbers don't come out right.
I tried this formula:
I butchered the formula and came up with this:
the closest I have come up with on my own, but the counts are still off versus a manual count:
P:P refers to the hh:mm:ss difference between the date opened and resolved in columns E & F (E, Date Opened,
1/6/2011 19:55, F, Date Resolved, 1/10/2011 17:22)
I:I refers to the work group name.
Q:Q is the number
from NETWORKDAYS, which has thrown me off because it counts any part of the day as a full workday.
C:C is the
status of the work order. I included that because originally the count was including work orders that were still open.
Any help getting an accurate time difference excluding weekends between the date opened and resolved would be greatly
appreciated! I can figure out the formulas to count them up if I can figure out how to get the time difference right.
Thank you all in advance!