Results 1 to 5 of 5

Need help with a formula to divide allotted hours over a period of weeks.

Threaded View

  1. #1
    Registered User
    Join Date
    07-26-2012
    Location
    Cincinnati, Ohio
    MS-Off Ver
    Excel 2013
    Posts
    15

    Need help with a formula to divide allotted hours over a period of weeks.

    I have a spreadsheet (attached) that takes user entered data (in the form of Allotted hours, weeks to complete, and due date), divides the due date by the number of weeks and returns the start date.
    The area to the right, separated out by week columns, contain cells with IF statements that check the dates entered against the week in which they fall, filter themselves out or return how many hours fall within that week.
    The problem that I am having is that if the start date falls in the middle of week, the cells return nothing and if the end date falls in the middle of a week, the cell returns the same amount of hours as the week before.
    I have reached the bounds of my current ability with formulas and do not code, anyone able to give me some ideas on how to proceed?
    Any help would be awesome.
    Thanks

    Matt
    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