Excel Rounding Up to Nearest Multiple

J

jshrader

I have a list of minutes spent on billable activites. Times are billed
in 15 minutes increments. For exampe 20 minutes would be rounded up to
30 minutes.

When I try to use the mround feature (mround(a3,15) where a3 = 15), it
rounds to the nearest 15 minute increment, or in this example down to
15 minutes.

Is there an option to combine mround with roundup to accomplish this?
 
R

Ron Coderre

Try this:

If your minutes are in A1
and are entered as whole numbers (12, 9, etc):
=CEILING(A1,15)

If they are entered as time (00:12, 00:09, etc):
=CEILING(A1,(15/(60*24)))

Does that help?

Ro
 

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

Round time to quarter hour 15
Rounding hh:mm to nearest 15, 30, 45 minutes 4
Round Up by a factor not by a digit [MROUNDUP(number,multiple)] 8
Round time up to nearest :15 2
Round time to nearest 15 minutes in decimal format 4
rounding to closest 15 minute increment 1
rounding up to nearest specified whole number 1
Rounding up or down decimals to the nearest 5 2

Top