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

      Hello,

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

      START_TMSTP                                      END_TMSTP                                                         DIFFERENCE

      06-NOV-18 05.30.00.000000000 AM    07-NOV-18 03.26.00.000000000 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