+ Reply to Thread
Results 1 to 6 of 6

Calculating END time based on start time, breaks, and hours to complete

  1. #1
    Registered User
    Join Date
    09-29-2011
    Location
    Georgia
    MS-Off Ver
    Excel 2007
    Posts
    29

    Question Calculating END time based on start time, breaks, and hours to complete

    I need help creating a macro that will use Cell A1 (now()), the penalties (amounts of breaks) per hour listed on the penalties tab, and the input data of hours and minutes to determine a completion time.

    The thing where I get confused is we have different "breaks/penalties" depending on the day of the week. I have listed all of those in the penalties tab.

    The Calc form B9 and B10 are what I want to populate with the macro.

    Can anyone help?

    Erin:
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-29-2011
    Location
    Georgia
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Calculating END time based on start time, breaks, and hours to complete

    I would really appreciate any help on how to do this?

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Calculating END time based on start time, breaks, and hours to complete

    Should the winding and connecting end times be calculated?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Registered User
    Join Date
    09-29-2011
    Location
    Georgia
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Calculating END time based on start time, breaks, and hours to complete

    yes - the connecting cannot begin until the winding has ended

  5. #5
    Registered User
    Join Date
    09-29-2011
    Location
    Georgia
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Calculating END time based on start time, breaks, and hours to complete

    Basically what happens is they wind and then they start connecting and we need what time it will be at the end of each of those processes

  6. #6
    Registered User
    Join Date
    09-29-2011
    Location
    Georgia
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Calculating END time based on start time, breaks, and hours to complete

    I have been thinking about it and I think my logic needs to be to look at the start time and and an hour - but then subtract the penalty times, then do the amount of hours for time given to complete the task and subtract 1, and run that through a while loop until the the amount of hours to complete is 0. I am just not sure what the syntax for this would be

  7. #7
    Registered User
    Join Date
    09-29-2011
    Location
    Georgia
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Calculating END time based on start time, breaks, and hours to complete

    sorry - I think I replied to this incorrectly. The connecting can't begin until the winding has ended. Do you have any suggestions? ANY help is greatly appreciated

+ 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