1 Reply Latest reply: Oct 5, 2018 2:42 AM by Petter Skjolden RSS

    Above Function

    David Young

      Hi All,

       

      I have the following information in a table:

        

      Sysif(IsNull(above(Sys)),0,Sys-Above(Sys))
      8/24/2018 8:270
      8/24/2018 8:510
      8/24/2018 8:510
      8/24/2018 8:590
      8/24/2018 9:32

      0

       

      I have the formula I am using where I want a running total but it is not working.  I would like it to show as time like:

       

      00:00:00

      00:00:09

      00:00:01

      00:00:08

      00:00:33

       

      I hope this makes sense.  All suggestions would be helpful.

       

      David