ExcelBanter - Round UP Time

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Round UP Time (https://www.excelbanter.com/excel-worksheet-functions/8837-round-up-time.html)

carl

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.

JE McGimpsey

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.

All times are GMT +1. The time now is 06:00 AM.