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)

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

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)

Try this:

A1 = 5:00 PM
B1 = 1:13 PM

=ROUND((A1-B1)*24/0.25,0)*0.25

--
Biff
Microsoft Excel MVP


"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)