Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i round time to the nearest half a minute | Excel Discussion (Misc queries) | |||
Round Time to 30 minutes | Excel Worksheet Functions | |||
Round up a time to the next 15 minutes | Excel Worksheet Functions | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
Round Up Time IF | Excel Worksheet Functions |