2 Replies Latest reply: Aug 24, 2012 5:36 AM by jimmygrollman RSS

    Remove time from another time

      Hello All,

      Say I have a field called 'InTime'.


      A pivot table then has the expression =TIME(InTime,'hh:mm')


      What would I like is to have this time minus five minutes.


      Any help would be much appreciated.