From Datetime field to 12 parts

H

hanu853

New member
Joined
Mar 30, 2015
Messages
2
Reaction score
0
Points
0
Hi friends,


I have datetime field in column M


I will take only Hour field from there.


After that if an hour is between


0-2 then "0AM-2AM"


3-4 means "2AM-4AM"


5-6 Means "4AM - 6 AM"




.....Like that it follows


the last one will be "10PM-12 AM".


Kindly help me to get VBA Code.


Regds,


Hanu:frusty:
 
Use a formula

=CHOOSE(INT(HOUR(A2)/2)+1,"0AM-2AM","2AM-4AM","4AM-6AM","6AM-8AM","8AM-10AM","10AM-12PM","12PM-2PM","2PM-4PM","4PM-6PM","6PM-8PM","8PM-10PM","10PM-12AM")
 
You must log in or register to reply here.
Back
Top