I would not use

to_date()

as that might be stripping off the time portion of your date time values. You should be able to do direct subtraction of datetimes. My past experience with Oracle suggests that date math gives results in days. You should just be able to multiply by 24 (as it looks you are already doing) to get hours.