  |
|
Home > Exploring Excel > How to Round Excel Time
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| "Using Excel's ROUND function, is it possible to push time into 1/4 or 1/2 hour increments? How would you do that? Hmmmm... " -- Doug W. |
Doug,
Sure. I did this quickly, so it probably could be simplified. But this formula rounds the current time into half-hour increments:
=INT(NOW())+ROUND((NOW()-INT(NOW()))/(1/48),0)*(1/48)
If you're interested in quarter-hour increments, you would use (1/96) rather than (1/48) in the formula.
Hope this helps,
Copyright © 2004 - 2012 by Charles W. Kyd, all rights reserved. Content, graphics, and HTML code are protected by US and International Copyright Laws, and may not be copied, reprinted, published, translated, hosted, or otherwise distributed by any means without explicit permission. Terms of Use | Privacy Policy | Earnings Policy.
Excel DashboardsLearn how to create top-quality dashboard reports with Excel. |
