VBA - Insert a IF function within an exiting coding.

Hello All,
I need to insert a piece of coding in an existing code and I am totally new to VBA. here is the original code :

Please Login or Register  to view this content.

What I want to do is to add a condition in the section : 'If weekend or weekday > 3pm.
I have a new column (column O) with 4 types of values possible : FULL, RESTRICTED, DESKTOP and RURAL.
what if want to do is : IF the value in Column O is FULL, RESTRICTED or RURAL then the part of the code :

Please Login or Register  to view this content.

Is to be applied. If the cell in column O is = DESKTOP, then this coding is not to be applied.

I don't know if it makes sense to you or not. Please let me know if you you need more info.

Thanks.

Thank you very much Nathansav! It worked my range is unknow (it can go anywhere between 150,000 rows 500,000 or more).
So how would you enter that in the coding?

OR for a range o1:o300000. Any idea anyone?