Round UP Formula for TIME [Solved/Closed]

Question

Round UP Formula for TIME [Solved/Closed]

Report

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.

Round UP Formula for TIME
If formula for time range - How-To - Excel
Excel formula converting time difference ✓ - Forum - Excel
If formula with time ✓ - Forum - Office Software
Excel repeat rows a specified number of times formula - How-To - Excel
Macro to copy/paste down X times (where X is the number of rows) ✓ - Forum - Excel

2 replies

Ask a question

TrowaD · Answer 1 · 2014-04-29T11:38:16-0400

Answer 1 / 2

TrowaD

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

448
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

ravibangera · Answer 2 · 2014-05-01T09:18:07-0400

Answer 2 / 2

ravibangera
May 1, 2014 at 09:18 AM

Trowa

Worked like a charm. Thanks a lot.

Regards

Ravi

Round UP Formula for TIME [Solved/Closed]

2 replies

Your reply

Subscribe To Our Newsletter!