Hi,

I have a numeric formula that calculates the amount of hours that have passed if a date/time exceeds 24 hours.

If([Delivery (hours)]>24,[Delivery (hours)]-24)

I would like to add the condition that if the field [Priority] matches a certain text that it change the result. Something like this:

If(

[Priority]="Normal" AND [Delivery (hours)]>24,[Delivery (hours)]-24),

[Priority]="Rush" AND [Delivery (hours)]>12,[Delivery (hours)]-12)

However because I'm now calling on a

*Text *field, QB complains about it because this is a

*Numeric* formula.

If I convert the formula to Text, now I can't calculate the numbers.

Can anyone help me with a way to do this?