Round time to quarter hour
=ROUND(A1*96,0)/96
or
=MROUND(A1,1/96)
format as h:mm
"pdberger" wrote:
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.
|