Forum Discussion
Calculating average turnaround time and per day contact
The attached workbook (now a .xlsm, so you'll have to allow macros) contains a custom function WorkingHours.
It completely ignores weekend days and holidays, I'm not sure that it what you wanted...
Try this:
=MAX(NETWORKDAYS(A17,B17,$E$2:$E$17)-1,0)+IF(AND(MOD(WEEKDAY(B17),7)>1,ISERROR(MATCH(B17,$E$2:$E$17,0))),MOD(B17,1),0)-IF(AND(MOD(WEEKDAY(A17),7)>1,ISERROR(MATCH(A17,$E$2:$E$17,0))),MOD(A17,1),0)
Thank you so much for your response!!
This has gotten me a little closer.
This formula is now calculating when the start & end times are on the 'days off'. However, I am still getting a negative value when the start date is 2021-05-03 3:41:00 PM but the response date is 2021-05-04 1:02:00 PM.
Any suggestions on this one?
The attached workbook (now a .xlsm, so you'll have to allow macros) contains a custom function WorkingHours.
It completely ignores weekend days and holidays, I'm not sure that it what you wanted...
- Again, thank you for this fantastic response. This looks like it is going to do what I need it to.
