The excel book im currently (and forever) updating is used to co-ordinate lessons and rides for boarders on horses. Currently if a boarder is taking a lesson they get onto the horse 15 minutes prior to the lesson If the trainer (David) is taking a lesson he gets on at the lesson start time since he is on another horse prior. Therefore i have the following code,
Code
=IF(ISERROR(IF(C18="David",B86,B86-TIME(0,15,0))),"",IF(C18="David",B86,B86-TIME(0,15,0)))My question stems from when i have a boarder taking back to back lessons for the second lesson they too have to get on the horse at the lesson start time and not 15 minutes prior thus my question if there is a simple way to add in a second stipulation to achieve this goal without having to manually change the time.