calculation of time

[balrammahato204]

Hi All,

Please help me

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.

Regards

Balram

[balrammahato204]

Sorry to all

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.

Regards

Balram