Forum Discussion
IF and TIME questions
Hi All, I am trying to build a spreadsheet for punch clock time rounding to the nearest quarter hour. If the time is 3 minutes before the quarter hour, I need the time to jump up to the nearest qua...
LScott2514 Perhaps with MROUND. See below.
Riny_van_Eekelen - Thank you!
That gets me closer, thank you so much. I just now need to incorporate the 3 minute rule. This is rounding based on dividing each quarter in half, rather than overwriting that with a three minute threshold.
