Rounding to the nearest 0.25

[sknight22]

Good morning,

I have a sheet that calculates waiting time and I am using

=IFERROR(MROUND(AF2,0.25),"")

to round up times to the nearest 0.25

I have a problem though. When a time is entered e.g 2.55 (2hrs 55mins) it returns 2.50 when I need it to show 2.75.

Is there a way to alter this to work?

Hope that makes sense

 

[sknight22]

Sorry for the confusion and the formula above works Perfectly - thank you so so much for your help.

 

[Phuoc]

Another way:

=MROUND(A2,"0:15")*24