1 2 Previous Next 20 Replies Latest reply on Dec 7, 2018 1:29 PM by Nico Heinze

    subtract two timestamp issue

    J Dos Active Member


      I have an issue with subtracting timestamps... Here is my data:

      START_TMSTP                                      END_TMSTP                                                         DIFFERENCE

      06-NOV-18 AM    07-NOV-18 AM                    -22:4


      Here is my logic:



      The correct time difference should be 21:56... I understand why I am getting 22:04, but I am not sure how to fix it! Any ideas?

        1 2 Previous Next