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.
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.
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 <[email protected]>,
"carl" <[email protected]> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks