locked
DiffInDays shows minutes instead of days RRS feed

  • Question

  • I created new field as following:  Data Type - Whole number, Field Type - Calculated, Format - Duration with formula

    Set Duration Time to DiffInDays(Created On, Actual Closure Date)

    The result appears in days but mentioning minutes. Here are examples:

    DiffInDays(16/03/2016 9:10 PM, 18/03/2016 9:01 PM) = 2 minutes

    DiffInDays(26/04/2016 5:21 PM 05/05/2016 1:49 AM) = 8 minutes

    Why appear minutes?

    Thank you in advance!

    Arkady.


    Monday, December 4, 2017 1:49 PM