|Delta Hours Tile|
The Delta Hours tile will return the difference, in hours, between two times. This tile ignores the minutes and seconds portion of time. The difference between 12:00 AM and 12:59 AM is 0 hours if the Delta Hours tile is used. The difference between 12:59 AM and 1:00 AM is 1 hour if the Delta Hours tile is used.
To arrive at fractional hour time results, use the Delta Minutes tile in your calculations and then divide the result by 60 to get hours. Be sure to format the output for 2 decimal places to get a fairly accurate decimal description of elapsed time in hours (e.g., 0.25 hours means 15 minutes).