1 Reply Latest reply on Jun 12, 2013 11:36 AM by Alex Kerin

    I need to find out how long my customers wait in the lobby, is there a DATEPART or DATEDIFF that can help?


      I collect two pieces of information related to wait time.

      1. Ticket Start Time and
      2. Customer Arrival Time


      My excel formula is" Wait time = Start time - Arrival time".  Here is the format for the times, minus the quote symbols.  "2/22/2013 1:34:47 PM".


      I have tried date part using "DATEPART('minute',[CUSTOMERARRIVALTIMELOCALTS] )+(DATEPART('second',[CUSTOMERARRIVALTIMELOCALTS])/60)"  but I keep getting negative numbers, I believe this is because I might have low minutes on the Start time, such as 5 min after the hour, and high min on the arrival time.