To make this calculation, you will need to compute it based on DATEDIFF and multiplying by number of hours in a day. Here are some details from the help documentation on the DATEDIFF function:DATEDIFF
Calculates the days, weeks, months between two dates.
DATEDIFF(DATETIME_1, DATETIME_2, INTERVAL)
DATEDIFF(@Date Received@, @Date Shipped@, “months”)
Notes on use:
The DATETIME you provide must be a datetime object, a column that contains a datetime object, or a function that returns a datetime object. The INCREMENT provided must be an integer. Millis accepts a maximum of +/- 2147483647.
It is recommended you use the latest datetime value for the DATETIME_2. If you enter the earliest date as the DATETIME_2 value, the DATEDIFF function will return a negative number.
DATEDIFF always rounds the result down to the nearest whole number. For example, if the difference between two dates is 3 years and 11 months, the DATEDIFF function returns the difference as 3 years.