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
Bookmarks