Previous Topic Next Topic

Round UP Formula for TIME

Solved/Closed
ravibangera Posts 1 Registration date Tuesday April 29, 2014 Status Member Last seen April 29, 2014 - Apr 29, 2014 at 03:30 AM
 ravibangera - May 1, 2014 at 09:18 AM
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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Apr 29, 2014 at 11:38 AM
Hi Ravibangera,

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

Don't forget to properly format you cells.

Best regards,
Trowa
0
Answer 2 / 2
ravibangera
May 1, 2014 at 09:18 AM
Trowa

Worked like a charm. Thanks a lot.

Regards

Ravi
0