Forum Discussion
Solved
Calculating average turnaround time and per day contact
Hi all! I am struggling with calculating turnaround time when it comes to communications coming in and being answered on a weekend or holiday. Platform: Microsoft Excel for Mac (version 16.49) ...
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...
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.