Situation
A Days function exists that only returns full days between dates.
Currently there is no function that returns a date with a timestamp including hours and minutes. I wanted to calculate the time / duration for incidents between incident start date-time and the date-time it was noticed.
This is currently not possible.
Complication
Durations or time (hours, minutes) between dates are needed for use cases such as time to detect for incidents, where DAYS function's result is to vague.
Resolution
Give me a function returning dates with timestamp and let DAYs or a new function return the time between days in hours or minutes.