TAT Calculation

[kitcha315]

Hi All,

I am working on TAT calculator sheet.

Coln A Coln B TAT
8/9/2010 17:00 9/9/2010 18:00 -

The above is the input format of data.

My requirement is
1) Weekdays 9:00 - 5:00PM should be considered same day
Anything after 5 PM should be considered next day
2) Weekends : Saturday 9:00 - 1:00 PM should be same day else monday
Sunday - Should be considered as monday

I am using Networkdays function. Please help with how to incorporate the Time schedules for weekdays and Weekends.

Thanks
Krishna

[Bob Phillips]

You need to give more detail on what TAT is and what the calciulations for same are.