ifference between times rounding up or down the minutes to .25...

[Surrey]

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)

 

[joeu2004]

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

 

[Rick Rothstein]

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

 

[T. Valko]

Try this:

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

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