200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
8:00 to 9:06 = 1.0 hrs
8:00 to 9:07 = 1.25 hrs
8:00 to 9:22 = 1.5 hrs
8:00 to 9:37 = 1.75 hrs
8:00 to 9:52= 2.0 hrs
I need a formula for excel that rounds to the nearest quarter after the 7th minute in each quarter. I have used =MROUND(D4-B4-C4,"0:15")*24 but this rounds up when it hits the 8th minute of the quarter. Thank you.
The basic formula is
=MROUND(A1*24,0.25)/24Here A1 holds the time to be rounded and the cell in which the formula resides is formatted as Time, as is A1.
Applied to the time you appear to want to round the formula might look like
=MROUND((D4-B4-C4)*24,0.25)/24 If you wish to slant the rounding to round up after 7 minutes instead of 8, just add 1 minute to the time you are about to round. That would then look like this:-
=MROUND((D4-B4-C4+(1/1440))*24,0.25)/24