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

S

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

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
 
R

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top