2 Replies Latest reply: Aug 23, 2017 4:43 AM by Antonio Mancini RSS

    Take Minutes (mm:ss) from DateTime (dd/mm/yyyy hh:mm)

    James Waller

      I have two columns, one is formatted as a date with time dd/mm/yyyy hh:mm:ss

       

      e.g. 02/01/2017 14:00:00

      and i have another column formatted as hh:mm like so

       

      00:10

       

      How would I remove 10 minutes, from the 14:00 time in the other column?

       

      I've tried Interval with no luck, and simply taking them doesn't seem to work so thought I'd come to the community for advise.

       

      Thanks

      James.