DECLARE @minutes INT
DECLARE @hours INT
DECLARE @time decimal(5,2) = 1.80
SET @hours = floor(@time)
SET @minutes = (@time - @hours) * 100
SET @minutes = @minutes + (@hours * 60)
SELECT @minutes / 60 + (@minutes % 60) / 100.0 AS Hours
How about this.......!!!!