How do I round time
I would like to know how to round five minutes to an hour and five minutes
after the hour to the nearest whole hour. (ex. round 7:55 and 8:05 to 8:00) Thanks, Ana |
How do I round time
With a time in A1, this formula will round up or down to the nearest
hour: =ROUND(A1*24,0)/24 However, this will round 7:31:00 up to 8:00:00 and 8:29:00 down to 8:00:00, which may not be what you want - if you have 7:50:00, do you want this to stay as it is? Pete Ana wrote: I would like to know how to round five minutes to an hour and five minutes after the hour to the nearest whole hour. (ex. round 7:55 and 8:05 to 8:00) Thanks, Ana |
How do I round time
See http://xldynamic.com/source/xld.Rounding.html#time
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Pete_UK" wrote in message oups.com... With a time in A1, this formula will round up or down to the nearest hour: =ROUND(A1*24,0)/24 However, this will round 7:31:00 up to 8:00:00 and 8:29:00 down to 8:00:00, which may not be what you want - if you have 7:50:00, do you want this to stay as it is? Pete Ana wrote: I would like to know how to round five minutes to an hour and five minutes after the hour to the nearest whole hour. (ex. round 7:55 and 8:05 to 8:00) Thanks, Ana |
All times are GMT +1. The time now is 09:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com