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?