On Jan 29, 11:10*am, Surrey wrote:
I would like to find out how to calculate the
difference between times rounding up or down
the minutes to .25 of an hour. *For instance,
(5:00:00 PM-1:13:00 PM) =3.75 (as a number)

If 5:00 PM is in A1 and 1:13 PM is in A2, then:

=mround((A1-A2)*24,0.25)

If MROUND is not available to you, then:

=round((A1-A2)*24/0.25,0)*0.25