Calculate TAT hrs by excluding Sunday and holiday's

[Sudhakar1523]

Hello everyone,

I'm building an escalation matrix for ticket resolution times, and I need to accurately calculate the working time between ticket creation and resolution. This requires excluding Sundays and holidays, while maintaining Saturday as a working day, within a 9 AM to 6 PM window. How can I achieve this?

I tried using the NETWORKDAYS function, but it also excludes Saturdays, which isn’t ideal for my case.

Below is the samle data.

Thanks in advance!

[morgankejerhag]

If network days doesn't work my trick is usually to assign each working day a number that increments. So days that are Sundays and holidays get the same day number as the previous working day. By subtracting the start working day number from the end working day number we get the number of working days in between.