[TABLE="width: 500"]
[tr][td][/td][td]A
[/td][td]B
[/td][td]C
[/td][/tr][tr][td][/td][td]Horse
[/td][td]Rider
[/td][td]Time
[/td][/tr][tr][td]1
[/td][td]Lucky
[/td][td]John
[/td][td]12:45
[/td][/tr][tr][td]2
[/td][td]Venus
[/td][td]Jane
[/td][td]1:45
[/td][/tr][tr][td]3
[/td][td]Zelda
[/td][td]Joe
[/td][td]2:15
[/td][/tr]
[/TABLE]
Im making a scheduling workbook, my current task im trying to accomplish involves organising ride times for horses. Column 1 Contains Horses, Column B riders, and C time. In my scenario if a student is riding they get on the horse 15 minutes prior to the time, if the trainer is riding he gets on at the set time in column C. Can someone help devise a formula that if cells in column B does not contain the word "John" to subtract 15 minutes from the adjoining cell in column C.
At the point of the document where i will be adding this formula, each cell if populated from another cell in the worksheet. so the cells actually look as such.
[TABLE="width: 500"]
[tr][td][/td][td]Horse
[/td][td]Rider
[/td][td]Time
[/td][/tr][tr][td]1
[/td][td]lucky
[/td][td]=bb60
[/td][td]=bd60
[/td][/tr][tr][td]2
[/td][td]venus
[/td][td]=bb61
[/td][td]=bd61
[/td][/tr][tr][td]3
[/td][td]zelda
[/td][td]=bb62
[/td][td]=bd62
[/td][/tr]
[/TABLE]
Any help would be much appreciated, i attempted an =If() formula, and will continue to try make it work unless anyone can help.