How to find total hours took from the ordered date to shipped date
Just use the datepart as an hour in the datediff() function and you will get difference in an hour.
DATEDIFF(hour, order_date, ship_date)