I tweaked the following formula so when the actual accrue is less than 40 hours, the cell will reflect that. 

=IF(E2<=40, E2, IF(DATEDIF(D2,TODAY(),"Y")<10,MIN(40,F2),80))
Example: 3/21/05 is 30.06 hours. I want the vacation time cell to reflect 30.06, not 40 hours.

When I use this formula: 
=IF(DATEDIF(DATE(YEAR(D2),1,1),TODAY(),"y")<10,DATEDIF(D2,TODAY(),"m")*3.34,DATEDIF(D2,DATE(YEAR(E2) +9,12,31),"m")*3.34+DATEDIF(DATE(YEAR(E2)+10,1,1),TODAY(),"m")*6.67)
my above formula will not work since anything over 10 years returns a 0.

Any ideas around this?

Thanks again!!!!!!!!!!!!!!!!!!!!!!!!!!