No ratings

How to get the number of days and hours from the dateDiffMinutes function?

Topic

How to get the number of days and hours from the dateDiffMinutes function?

 

Instructions

The result needs to be multiplied by 24 i.e

=([Start Time]-[End Time])*24
 

Additional Information

When using the DateDiff.... functions the output will always be a positive integer.

The reason for this is as follows.

The number of days between today and tomorrow is equal to 1.

The number of days between today and yesterday is also equal to 1.  it is not negative 1.

Labels: (1)
Version history
Last update:
‎03-09-2021 03:15 PM
Updated by:
Contributors