I've been trying to create an =if formula which runs off an =now formula. The question i have is if anybody could help me produce a if function which states when an =now() displays the times between 18:00 and 20:00 a £5 deduction is taken from an overal price, but when its any other time the deduction is simply 0.

I will be able to deduct the amount from the total value its just i can't seem to tell the if function to look for only the times between and including 18:00 and 20:00.

If anybody could help me with this or state a way it can be done will be very appreciated.

Thanks in advance,

Tom