You just need to change this line: RETURN DATEDIFF(StartHour, EndHour, HOUR)

to

RETURN DATEDIFF(StartHour, EndHour, MINUTE)

If you wanted to a fractional hour, you'd divide by 60 RETURN DIVIDE(DATEDIFF(StartHour, EndHour, MINUTE),60)