If statement off cells that are time formatted

I have to build an "IF" statement off time card punches. Its a pain in the *** and I figured Id come on here and look for help.

Below is an example of what I am working on. I would need the if statement to analyze the punches. Specifically something that says "if,D2(CLOCK OUT
CELL)<5:00PM,"PICKUP","DROPOFF".
Trying to see the history of deliveries....

Hopefully someone may be able to assist as I keep getting errors....


Date Clock In In Code Clock Out Out Code
Monday, August 10, 2015 8:03AM 4:37PM
Tuesday, August 11, 2015 9:06AM 5:45PM
Wednesday, August 12, 2015 9:37AM 5:52PM
Thursday, August 13, 2015 8:09AM 4:44PM
Friday, August 14, 2015 9:13AM 5:29PM

Does
D2 contain TIME only, or is it Date+Time ?

This will return TRUE if it's time only, False if its both
=AND(ISNUMBER(D2),D2<1)