i have this algorithm that i would like to change into vba, but i am very new to vba.

i will like to find party participants for certain times.
it goes like this:

i would like to find users
-who had two parties in a day, or
-had 3 parties in a day. or
-had two parties in a day and had one more party before and after their 2 parties in the day.

the party time goes like this:
8am, 12noon, 6pm. - 3 parties
8am 12noon or 12noon 6pm - 2 parties. and the before or after their parties.

i have basic excel forumulas to compute, but not sure how to put that into vba.
any ideas please.