+ Reply to Thread
Results 1 to 3 of 3

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

  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

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,674

    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
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    11-23-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    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.

+ Reply to Thread

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