2 Replies Latest reply on Jul 29, 2015 7:25 PM by Bevan Hirst

    Help me add minutes to my equation!

    Bevan Hirst

      Hi guys

      I'm using the following equation to determine the number of people finishing after a certain time, in this case 3pm:

       

      COUNTD(if([DateTimeEnded (Hours)])>=15 then [Employee Number] end)

       

      I actually want to determine how many people finish after 3:30pm

      How is this possible?? I've tried adding decimals '15.5' but then it just calculates the threshold @ 4pm instead

      I tried using dashes '15-5' but I believe this number is then converted to a date function.

      Can someone help?

      Thanks