Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Round UP Time
I have a time stamp like this:
11:23:20 AM I would like to find a funtion that rounds the time up to the next whole minute: 11:24:00 AM Is it possible ? Thank you in advance. |
#2
|
|||
|
|||
Time in XL is stored as fractional days, so rounding up to 1/(24*60)
will work. One way: =ROUNDUP(A1*1440,0)/1440 or =CEILING(A1,"0:1") In article , "carl" wrote: I have a time stamp like this: 11:23:20 AM I would like to find a funtion that rounds the time up to the next whole minute: 11:24:00 AM Is it possible ? Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Round Time | Excel Worksheet Functions | |||
Round Time | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
How do I round time? | Excel Worksheet Functions |