1 Reply Latest reply: Nov 5, 2017 5:48 PM by Glenn David RSS

    How to calculate different between two time,date fields and eliminate at the same time

    Ameen Mahfouz

      Hi, I hope someone can help me on this!

       

      I have created a new table like this

      New Field.jpg

      I have two fields

      1. createdAt (represents when a request is created)
      2. DispatchedOn (represents when a request has been dispatched)

       

       

      What I want:

      1. I want to first calculate minutes between creation time, and dispatching time
      2. I want to eliminate the hours and the days we do not work

       

      We only open from 8:00 am, to 18:00 pm and we don't work on Fridays

       

       

       

       

      I would appreciate the answers to the two points I need to do,