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
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.
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:
- Round UP Formula for TIME
- Popcorn time download - Download - Movies, series and TV
- Ocarina of time rom - Download - Action and adventure
- Logitech formula vibration feedback wheel driver - Download - Drivers
- How to change time in whatsapp - Guide
- Number to words in excel formula - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 29, 2014 at 11:38 AM
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
Try this formula:
=CEILING(A2,1/24)
Don't forget to properly format you cells.
Best regards,
Trowa
