CHD's Memory
Monday, February 27, 2012
Excel: How to round time up to the nearest minute
Wow, super easy. Use CEILING(
,1/24/60). Here is the blog post with the secret:
http://www.excel-answers.com/microsoft/Excel-Miscellaneous/32063156/roundup-time.aspx
Here is a much harder method for doing it, using TIME, HOUR, and MINUTE:
http://stackoverflow.com/questions/1372924/round-time-to-nearest-15min-interval-in-excel
Newer Post
Older Post
Home