Forum Discussion
Charting accrued hours and want to stop at maximum of 40. Formulas are set, but must stop at 40.
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 t...
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.