I am creating a tracking spreadsheet for vacation time (earned every
paycheck). Our company allows for negative balances. Below is the formula
that I am using:

=TEXT(IF((E9+C11-D11)A11,A11,( E9+C11-D11)),"[H]:MM")

It errors on the next paycheck if the result is negative.