5 Replies Latest reply: Jul 23, 2014 12:11 PM by Colin Albert RSS

    Time Calculation - Data Issue

      Dear Experts,


      Need your big help in this logic.I tried several ways and I couln't figure out the answer.


      Initially the data was good and I found the answer from Massimo Grassi to calculate the time difference from "In Process" to "Complete"


      But now the data is not in proper flow.Some time they are updating directly as "Completed" and then they are starting "In process" and update "Complete" twice.due to which our earlier logic is not working correctly.


      Could you please guide me with the below points


      1.Even though it is updated as "Completed" in the first instance if we have the second instance of "In process" it should consider that as a start and then it should take the "Complete" in the maximum date/time(if we have two complete).


      2.If any team/request which is carried to the next week it should ignore some specific hours in the weekend(Friday 7PM to Monday 8 AM)these times shouldn't influence the overall time taken for the team.


      Attaching the application and the sample.


      Request your help.


      Re: Time Calculation contd..


      Thanks & Regards