I am setting up an estimating spreadhseet for a construction company. Daily, they pay 8 hours of straight time and everything after 8 is over time, except Sundays & Holidays are paid at double time.
I wanted to be able to input the number of personnel by craft x the number of days & hours per shift for a day and night shift to get a man hour total split up by straight time, over time and double time. Mostly, the estimator will fill in the number of craft per day or nigh shift, and the red items.
I think I have the straight time man hour claculation/formula figured out and probably the over time. My problem seems to be the double time formula and getting it to deduct the straight time and overtime from the total. (May be that I am making this harder than needed?)
So my issue is with the formula in cell C91 and something has to happen to the formulas in C89 and C90.
Bookmarks