IF Statement Help

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 out. Specifically something that says "if,D2(CLOCK OUT
CELL)<5:00PM,"PICKUP","DROPOFF". I keep getting an error bc its not able to read the time format I believe.
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

Sounds like you are almost there? Are you having a problem with the time part? If so, use the TIME() function...
TIME(17,0,0)

If that was not your problem, Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )