2 Replies Latest reply: Jun 10, 2013 6:16 AM by Mohit Sharma RSS

    count of time field

      Hi,

       

      I have a time field (hh:mm:ss) in a field called update_time_JD_1.  What I am looking to do is create an expression that counts the data that is over 10 hours but I do not want it to count the data over 20 hours.

      E.G.

       

      00:00:05

      00:10:05

      05:10:09

      10:10:10

      13:16:19

      20:02:30

       

      This would show the count as 2, as I want it to show the 10:10:10 and 13:16:19, but not the 20:02:30 (even though its over 10 hours).

       

      Regards,

       

      Jon Ditchfield