Macro formula

[sloan0462]

Hello im in need of a macro which will enter the following formula.
-(T-S)/1.8
this needs to look at the relevant row so if row 8 the formula needs to be.
-(T8-S8)/1.8
if row 9
-(T9-S9)/1.8

i need the macro to look in a certain range for whether or not a cell contains the following (Todays- shipment)
the cell that contains this will have other writing within it but it will always say (Todays- shipment) how it is shown here.

So if (Todays- shipment) is found in a cell between Q8 and Q31 i need it to enter the formula in column R for the relevant row.

to make matters more complicated if the beginning of the cell that contains (Todays- shipment) starts with the word (Time) i need the formula to be

-(T-S)/1.2

Can this be done?

Any help would be great thank you

 

[sloan0462]

Could this code be modified slightly, what i need instead of when it finds the text in O then making the formula look at that particular row for the first offset i.e. "=-(T=", i need it to look in column o for the word loop and then do the offset when it fins that. so if it finds loop in cell O9 the formula first part of the formula would b T9 making a complete formula of

=-(t9-s9)/1.2

i still need the formula to be entered in the same cell though.

Could you help, it this possible?