4 Replies Latest reply on Jun 12, 2018 8:34 PM by Vijay Kumar MV

    Difference Calculation between times

    elias.daniels.0

      Hi all,

       

      A simple question.

       

      How can I get the time difference in hours or minutes, for two different times.

       

      For example:

       

      Time 1

      26/05/18

      17:40

       

       

      Time 2

       

      27/05/18

      02:30

       

      Result should be: 8.83 Hrs or 530 mins

       

      I have been trying to use timediff, but I'm struggling with negative results.

       

      Also, can you please advise how to format the time to be in 24Hrs format.

       

      Thanks in advance,

       

      Elias