Round UP Formula for TIME [Solved/Closed]

Report
Posts
1
Registration date
Tuesday April 29, 2014
Status
Member
Last seen
April 29, 2014
-
 ravibangera -
Hi All. I need an excel macro to populate a cell with a time slot based on the previous column which is a datetime value. e.g.
if column A is 1-Apr-2014 1:57 PM, column B will show time slot as 2:00 PM,
if column A is 1-Apr-2014 11:15 AM, column B will show time slot as 12:00 PM,
if column A is 1-Apr-2014 3:25 PM, column B will show time slot as 4:00 PM
and so on and so forth.

Please guide on this. Thanks in advance.

2 replies

Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
Hi Ravibangera,

Try this formula:
=CEILING(A2,1/24)

Don't forget to properly format you cells.

Best regards,
Trowa
Trowa

Worked like a charm. Thanks a lot.

Regards

Ravi

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!