# Excel Formulas for Calculating Straight, Over Time & Double Time in Cost Estimating

1. ## Excel Formulas for Calculating Straight, Over Time & Double Time in Cost Estimating

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.

2. ## Re: Excel Formulas for Calculating Straight, Over Time & Double Time in Cost Estimati

In your spreadsheet, are you calculating 3 workdays or 2. It is not clear if the double time day is a third day or the second day.

Alan

3. ## Re: Excel Formulas for Calculating Straight, Over Time & Double Time in Cost Estimati

The number of days (Cell C81). can be variable from 1 to whatever What is show is 2 work days with one of them (Cell C82) being a Sunday.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1