Results 1 to 3 of 3

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

Threaded View

redhairredhair Excel Formulas for... 11-23-2010, 08:35 PM
alansidman Re: Excel Formulas for... 11-23-2010, 08:43 PM
redhairredhair Re: Excel Formulas for... 11-23-2010, 09:06 PM
  1. #1
    Registered User
    Join Date
    11-23-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Bookmarks

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