Charting accrued hours and want to stop at maximum of 40. Formulas are set, but must stop at 40.

[Mark_Stibbe]

I am charting accrued work hours and applying formulas to calculate a benefit for each hour worked.  Once I achieve a value of 40 hours, I want it to stop calculating.  Is there a way that I can do this?  

[#2]

@Mark_Stibbe 

Well, to accomplish that, you must change your "set" formulas, or optionally calculate the time-limited values in a separate set of cells and chart those instead.  Use Excel's MAX function.

I'll assume that your calculations are using time in Excel's representation, which is the fractional portion of a day; so 1 hour = 1 (hour) / 24 (hours per day), and 40 hours = 40/24 (or 1.66666…, but I recommend using the fractional notation).

The 40/24 can be either the first or second parameter to the MAX function; the order does not matter. The other parameter is the portion of your formula that represents your calculated time.