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.