3 Replies Latest reply on Sep 5, 2014 2:14 PM by Emil Jimenez

    Using DATEDIFF with multiple START and END Dates

    Emil Jimenez

      Hi, I was wondering if it was possible to use the DATEDIFF Function (or any other function) to get the (minute) difference between two date time points using multiple start and end points.

       

      The formula would conceptually look something like this...

       

      DATEDIFF('minute', [1st Start Time] [2nd Start Time] [3rd Start Time], [1st End Time] [2nd End Time] [3rd End Time])

       

      In the above formula =  I would need to be able to find the earliest Start and End time and only just use those two time points to get my 'minute' difference. The other start and end date times would just be ignored since they occured later.

       

      I was wondering if this was possible? Thanks! Any help would be greatly appreciated

       

      Emil