macro to change the cell value if it more than 24?

[tonywatsonhelp]

Hi Everyone,

I'll try describe this the best I can.

I have set up a time sheet with star times and end time in range G8:AAA80
I just want a macro that says if on change the cell value is greater than 24 then divide by 100

please help if you can

Tony

 

[AliGW]

If the value in the cell is derived from a formula, you might not need a macro.

 

[AliGW]

For example, if the formula in the cell is this:

=B1*C1

then change it to this:

=IF((B1*C1)>24,(B1*C1)/100,B1*C1)

 

[tonywatsonhelp]

Hi Aligw,

thanks but its not the values are typed in