You may need to recheck your typing, or your initial value.

To be accurate you should use 1/96 instead of 0.010417, as the latter has
some rounding errors from the true value of 0.0104166666666... (with the 6s
continuing to infinity), but the 0.010417 will give 7:15 AM if A1 is simply
7:12 AM. Why don't you reread your formula, and see whether you've used
=MROUND(A1,0.01047) instead of =MROUND(A1,0.010417)?

The other thing which might exaggerate the rounding error if you have got
0.010417 would be if A1 isn't just a time but contains date and time, merely
formatted as time.
--
David Biddulph

"pdberger" wrote in message
...
Good afternoon --

I'm having problems setting up a time sheet template, which requires
rounding the employee's time to the nearest quarter hour. Here's what
I've
got:

A B
1 7:12 AM =MROUND(A1,0.010417)

The 0.010417 number I believe to be the decimal value for 15 minutes. At
any rate, the resulting figure in cell B1 is 7:17 AM, instead of 7:15 AM
like
I want.

What am I doing wrong?

Thanks in advance.