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.
Related:

2 responses

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
The system time is invalid
LeonardPromise -
Anonymous User -

5 responses