how to round off 23.01 as 24 in sql server

Question

i dont no how to roundoff 23.01 as 24 ans

how to get between hours from hour and tohour

select datediff(hh,'18:00','20:35')

here im getting hour difference is only 2 but actually the difference is 2.35

how to select exact hour difference