+ Reply to Thread
Results 1 to 7 of 7

populate weekly hours based on Start and End Date

  1. #1
    Registered User
    Join Date
    02-24-2012
    Location
    ATL, GA
    MS-Off Ver
    Excel 2010
    Posts
    7

    populate weekly hours based on Start and End Date

    Hi,

    I am trying to populate hours in column F of attached based on start and end dates in columns C and D.

    Thank you,
    RD

    Capture.JPG
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-26-2021
    Location
    serbia
    MS-Off Ver
    365
    Posts
    11

    Re: populate weekly hours based on Start and End Date

    ,,,,,,,,,,,,,
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by scrzzt; 01-30-2021 at 08:03 PM.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,167

    Re: populate weekly hours based on Start and End Date

    Sorry for off-topic interjection:

    Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

    I'm sure you understand.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  4. #4
    Registered User
    Join Date
    02-24-2012
    Location
    ATL, GA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: populate weekly hours based on Start and End Date

    Quote Originally Posted by scrzzt View Post
    ,,,,,,,,,,,,,
    Thank you so much - I tried that earlier too but what I am trying to get is it will auto populate the Standard Hours in column F for the date range identified in columns C and D.
    I have attached with added row as an example.

    Thanks again!
    RD
    Attached Images Attached Images
    Attached Files Attached Files

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,167

    Re: populate weekly hours based on Start and End Date

    In G5 copied across and down:

    =IF(AND(G$2>=$C5,G$3<=$D5),$F5,0)

  6. #6
    Registered User
    Join Date
    01-26-2021
    Location
    serbia
    MS-Off Ver
    365
    Posts
    11

    Re: populate weekly hours based on Start and End Date

    What do you mean when you say STANDARD HOURS?

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,167

    Re: populate weekly hours based on Start and End Date

    It's a column in the workbook (F).

    Solution from post #5 in the attached workbook.
    Attached Files Attached Files
    Last edited by AliGW; 01-31-2021 at 01:07 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 03-06-2020, 08:35 AM
  2. [SOLVED] Calculating Target Date/Time Based on Start date and hours - Excel 2007
    By chinraj in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 12-09-2019, 01:43 AM
  3. [SOLVED] Calculating Target Date/Time Based on Start date and hours - Excel 2007
    By praddsouza in forum Excel General
    Replies: 7
    Last Post: 10-07-2018, 09:18 AM
  4. [SOLVED] Function for finding weekly average hours based on date
    By psa916 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-15-2013, 03:22 PM
  5. Calculate START date based on duration (work hours) and END date
    By kaaver in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-06-2010, 12:21 PM
  6. Calculate start date based on working hours and end date
    By kaaver in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-28-2010, 06:58 AM

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