3 Replies Latest reply: Nov 19, 2015 11:11 AM by Stefan Wühl RSS

    Calculating hours between 2 timestamps

      Hi I have 2 fields Logged on and Closed on.

       

      I want to calculate the number of hours between the 2 excluding weekends and the working day is only 7am to 5pm.

       

      If a case is opened and closed outside of this time then i want it to return a 0.

       

      Does any one know the correct formula for this?

       

      thanks,

      laura