Complex Formula Involving Dates & Times -

Hello,

I hope someone can help as this is not a very easy formula. I need to extract the first and last "appointment" for each date. I would like to return a 1 for those appointments (first and last) and a 0 for any appointment in between for each day. The information is found under column B = Start. I have also duplicated this information into numbers/digits in column C. In addition, I also need a formula to do the reverse and return a 1 for "intraday" appointments while returning 0's for the first and last appointment. Thank you in advance for any help!


Ex:

7/3/17 8:00am = 1
7/3/17 8:30am = 0
7/3/17 9:00am = 0
7/3/17 10:00am= 0
7/3/17 11:00am = 0
7/3/17 12:30am = 0
7/3/17 3:00pm = 1
7/4/17 8:30am = 1
7/4/17 9:15am = 0
7/4/17 2:00pm =1