3 Replies Latest reply on Jan 31, 2018 5:02 PM by sunil.sachdeva

    Calculation issue

    AJ.Yusuf

      Hi All

       

      Have a problem guys, I have done a calculation based on moving a car by a reg and what the calculation does is

      e.g

       

      car a moved at 9:00am to 10:00am

      car a moved again at 14:00:15:00

       

      instead of looking at each movent

      for example both movements were 1 hour each

      it calculates by looking at the last given movemnt so 15:00 - 9:00 which makes it 6 houus, this is distroting my data. Not sure waht do to? I have attached the workbook

       

      thanks

       

      Formula :

      IF [Time] = {FIXED [First Name],[Last Name], DATE([Time]),[Regn] : MAX([Time])} AND {FIXED [First Name],[Last Name] , DATE([Time]) , [Regn] : COUNTD([Time])} > 1 THEN

      {FIXED [First Name],[Last Name], DATE([Time]), [Regn] : MAX([Time]) - MIN([Time])}

      ELSE NULL

      END