Time Rounding

G

Guest

Try this:

=MROUND(B78*24,0.25)/24

tod
-----Original Message-----
Hi,
I'm trying to round minutes to the nearest 15 minutes
Click to expand...
(floor) and am using the following formula but it is not
working. Can someone tell me what I am doing wrong?
 

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

Similar Threads

rounding a number up to a certain ending digit 6
Round Up and Round Down Time 2
Rounding Time to Nearest 5 Minutes 1
Round time to quarter hour 15
Divide a # into 3 #'s rounded to a whole # 9
Excel Rounding Up to Nearest Multiple 2
Round time up to nearest :15 2
MROUND error showing 7

Top