+ Reply to Thread
Results 1 to 3 of 3

Estimating with Excel

  1. #1
    Registered User
    Join Date
    10-06-2010
    Location
    Borger, Texas
    MS-Off Ver
    Excel 2003/2007
    Posts
    2

    Estimating with Excel

    I have a spreadsheet to help with estimations, but when I throw a 6 day work week in the fields it does not calculate correctly. I have attached a sample of the worksheet. From the worksheet if I have 6 workdays it places 48 hours in regular hrs and 12 hours in OT hrs. How can I correct this?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-06-2010
    Location
    Borger, Texas
    MS-Off Ver
    Excel 2003/2007
    Posts
    2

    Re: Estimating with Excel

    Oops! I removed the formulas in worksheet so here it is again in current format.
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Estimating with Excel

    It's doing exactly what you told it to do.
    You have 10 hrs a day, so that's a total of 60 hours. From this you are figuring OT as (10-8) for each of those six days. That's 12 hrs of OT and remining are reg [48] hrs.

    Do you want only first five days [8 hrs each] to be regular and all hrs on sixth day to be OT?

    see attached sample.
    Is this what you want?
    modytrane
    Attached Files Attached Files

+ 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