Try this formula...

=MROUND(24*(A1-B1),0.25)

The MROUND function requires the Analysis ToolPak add-in (to install it,
click on Tools/Add-Ins on Excel's menu bar).

--
Rick (MVP - Excel)


"Surrey" wrote in message
...
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)