when reading the exception to reg Q I can tell if it is saying that it can be either tied to the balance or duration or if both.
Because we were going to offer a bonus to a business checking account based on a certain opening balance but how long they keep it will not matter

Both. The exception in §217.101(b) states:

(b) Notwithstanding paragraph (a) of this section, any premium that is not, directly or indirectly, related to or
dependent on the balance in a demand deposit account and the duration of the account balance shall not be
considered the payment of interest on a demand deposit account and shall not be subject to the limitations in
paragraph (a) of this section.

If you don't have both a minimum balance OR a duration requirement, you don't have to limit the "bonus" as required in §217.101(a) - (to $10).

What about giving a bonus for a service such as if a bonus sets up a business checking account and sign up for 6 months of bill pay they get a bonus

Tying the bonus to a product or service in addition to the checking account is a favorite way of getting around the rule, because the bonus is paid for the auxiliary service (bill payment, direct deposit, debit card, etc.), not for the DDA account.

thank you the only thing I was worried about was requiring them to sign up for bill pay for 6 months which of course they would need to have a checking account to continue with bill pay for 6 months