8 Replies Latest reply on Sep 15, 2016 9:13 AM by kettan

    How to subtract dates?

    Zeeshan Hussain

      I have two date/time fields which have been formatted only to show the hour and minute.

       

      I am trying to subtract a start time from an end time.

       

      I am attempting this by writing the following in a calculated field:

       

      DATEDIFF('minute',[end time], [start time]).

       

      I have also set the format for the calculated field to custom with hh:mm AM/PM

       

      When I drag this calculated field onto the column, nothing is displayed.

       

      Help would be appreciated, thank you.