Hello All,
I'm trying to figure out how to create a TAT formula that includes weekends. We have the following columns:
A1 - Shows what date and time we were working on emails at the end of the day (5:30PM)
B1 - Simply lists "5:30 PM" to illustrate that is when we worked on the time in A1
C1 - This column needs to display the TAT
We also have D1:D6 with days off for the year
I am only able to located TAT including NETWORKDAYS, but I need a TAT including weekends.
Thanks!!
I'm trying to figure out how to create a TAT formula that includes weekends. We have the following columns:
A1 - Shows what date and time we were working on emails at the end of the day (5:30PM)
B1 - Simply lists "5:30 PM" to illustrate that is when we worked on the time in A1
C1 - This column needs to display the TAT
We also have D1:D6 with days off for the year
I am only able to located TAT including NETWORKDAYS, but I need a TAT including weekends.
Thanks!!