Find the net elapsed time of a task [Closed]

Report
-
Hello,


I need to calculate the effective time taken by a task. I have the start date&time and end date&time of the task. Both the times are maintained at different time zone..Say UK time. The task's start time should be considered if the task is started within 9:00 AM to 18:00 PM of India Standard time,. Incase the tast start time is outside 9:00 AM to 18:00 PM of India Standard time, the formula should consider next working date 9:00 AM as the start time. Also, if weekend or holidays fall within the start date&time and end date&time range, only NETWORKDAYS should be considered.
Can any one please help me in getting the correct formula?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!