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.

       

      Regards,

      Jim