Previous Topic Next Topic

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

Answer 1 / 2
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
 487
Hi Ravibangera,

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

Don't forget to properly format you cells.

Best regards,
Trowa
Answer 2 / 2

Trowa

Worked like a charm. Thanks a lot.

Regards

Ravi
Ask a question