Software

=IF (A3 >= 140,IF(AND(DAY(TODAY())>=DAY(A3),YEAR(TODAY())=YEAR(A3)),(MONTH(TODAY())-MONTH(A3))*3.34,IF(AND(DAY(TODAY())<DAY(A3),YEAR(TODAY())=YEAR(A3)),(MONTH(TODAY())-(MONTH(A3)+1))*3.34,IF(AND(YEAR(TODAY() >YEAR(A3)),(YEAR(TODAY())-YEAR(A3)<10),DAY(TODAY())>=DAY(A3)),(((MONTH(TODAY()))*(80/12))+((12-MONTH(A3))*3.34)+((YEAR(TODAY())-(YEAR(A3)+1))*80)),IF(AND(YEAR(TODAY()>YEAR(A3)),(YEAR(TODAY())-YEAR(A3)<10),DAY(TODAY())<DAY(A3)),(((M O NTH(TODAY())-1)*(80/12))+((12-MONTH(A3))*3.34)+((YEAR(TODAY())-(YEAR(A3)+1))*80)),"N/A")))),"")

Thanks! Yet now my massive formula isn't working. Instead of getting their actual accrued hours, I'm getting all "N/A"'s. Maybe this will help- This formula is for employees who have worked 1 month-9 yrs. So the formula is based off of hire date and then accrued at 3.34hrs per month. The most anyone can have though is 40 hrs.(actually 40.08=3.34*12) But I only need the formula to run if they have worked at least 140 hours the prior month. I download the prior months hours worked from an ODBC source so I don't have to actually figure this up thank goodness!

I hope this makes sense?

Your cell should separate the date hours rendered in prev month and the date hired. In your example, your cell is only a3. So assuming you have cell a3 as hours rendered and cell a4 as
date hired the formula (you need to install analysis toolpack in your addin for this formula to work)
=IF(A3>=140,MIN(3.34*12,DATEDIF(A4,A9,"m"))*3.34,"n/a")

To make the logic more readable create a function and passparameters to it. This way it can be more structured and easy to maintain.