I have script for calculation of time difference between two dates. In this script my "Start date" and "End date" is following all these condition.
Taking only working hour 08:00:00 to 18:00:00
Excluding Public Holiday
Excluding weekend
But my problem is i have one more field name is "TotalPendingDuration", and i am using this field to calculate my "workingIntervel" calculation. I am getting ambiguity output Because of my all fields are taking working hour 08:00:00 to 18:00:00 and "TotalPendingDuration" is not taking the time 08:00:00 to 18:00:00.
So please suggest me how can i put all above maintain condition in my "TotalPendingDuration" .
for ex-In this qvw file if you have a look then you can see ID002 is giving the wrong output.
For better understanding please find the attached qvw file.
In my explanation i forget to maintain my calculation is excluding the time between status "Pending" to immediate "InProgress".
3/20/2015 10:00:00 AM,Pending
3/20/2015 11:00:00 AM,In Progress
ID002,3/20/2015 01:00:00 PM,Pending
ID002,3/20/2015 02:00:00 PM,Pending
ID002,3/20/2015 03:00:00 PM,In Progress
if this situation will come then my calculation is exclude the time it means from the first condition 1 hour and second condition 2 hour. Total hour is 3 hr excluding from the WorkingInterval.
Ambiguity will come in this calculation when "TotalPendingDuration" time is exclude from 10 hour.
