Add TAT 'x' hours with the Start Time excluding Non-business days and hours
I've an issue with complex criteria while adding a TAT hours with the Start Time.
Column D: Request In Time
Column F: TAT in hours (Turn Around Time)
Column G: Due Time (Which needs to be calculated. I.e: Result)
My team Shift Starts @ 06:30 PM and ends @ 06:30 AM.
I would like to add the TAT in hours with Request in Time by excluding the time outside my Shift hours and weekends.
It would greatly appreciated if you could help me with this.
Thanks a lot in advance.
Last edited by Praburam; 04-07-2011 at 01:49 AM.
Reason: Attachment Missed out
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1