Hello,

I have a macro that add rows and I fill them with data.
I want to insert to onw of the rows a formula so it will be available in the added rows.

the formula is:

=IF(E9="שבת","00:00",IF(K9-J9<0,"00:00",K9-J9))
any idea?

Thanks