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
=([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.