How to create TAT including weekends??

[cbjornn]

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!!

 

[Gerald Higgins]

Hi. What do you mean by TAT ?

 

[cbjornn]

Hi. What do you mean by TAT ?

My apologies. Turnaround time.

 

[Gerald Higgins]

OK thanks. Can you give us 2 or 3 different examples of what exactly you want to do please ?