ExcelBanter - Round time up to nearest :15

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Round time up to nearest :15 (https://www.excelbanter.com/excel-discussion-misc-queries/214025-round-time-up-nearest-15-a.html)

Amy

Round time up to nearest :15

I am currently using this formula to round to the nearest :15 --
MROUND(D2,0.25/24)
However I Need it to round UP to the nearest :15.

Any suggestions?

Mike H

Round time up to nearest :15

Try

=CEILING(D2,1/ (24*4))

Mike

"Amy" wrote:

I am currently using this formula to round to the nearest :15 --
MROUND(D2,0.25/24)
However I Need it to round UP to the nearest :15.

Any suggestions?

Amy

Round time up to nearest :15

Thank you, perfect

"Mike H" wrote:

Try

=CEILING(D2,1/ (24*4))

Mike

"Amy" wrote:

I am currently using this formula to round to the nearest :15 --
MROUND(D2,0.25/24)
However I Need it to round UP to the nearest :15.

Any suggestions?

All times are GMT +1. The time now is 04:17 PM.