+ Reply to Thread
Results 1 to 2 of 2

Speading Activity Hours over schedule in weekly increments.

  1. #1
    Registered User
    Join Date
    02-24-2021
    Location
    Adelaide
    MS-Off Ver
    2010
    Posts
    6

    Speading Activity Hours over schedule in weekly increments.

    Hello World,

    I'm trying to spread the allocated hours of a list of activities over a schedule in weekly increments.
    This spread would then be used to create an s-curve in graph.

    I've attached an example, which will hopefully explain things much easier.

    Regards,

    Bolesy
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    833

    Re: Speading Activity Hours over schedule in weekly increments.

    Hi, welcome to the forum,
    What if you use a formula like this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and copy this down and to the right.

    Cheers
    Erwin
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...

+ 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. Auto Create Daily Break Schedule from Weekly Work schedule
    By colema62 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2021, 04:31 PM
  2. [SOLVED] Total number of hours by person from a weekly schedule
    By [email protected] in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-30-2015, 05:18 PM
  3. Creating a Bi-Weekly Work Schedule with Total Hours.
    By DauntlessDS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-31-2015, 07:53 PM
  4. [SOLVED] Weekly increments problem
    By Ricksterr94 in forum Excel General
    Replies: 4
    Last Post: 07-29-2014, 02:45 PM
  5. [SOLVED] Add 2.433 hour increments to a starting number of hours every 24 hours
    By Juleskor in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-26-2013, 02:27 AM
  6. Weekly schedule to add up hours to be worked
    By Dxysis3 in forum Excel General
    Replies: 0
    Last Post: 03-19-2012, 11:18 PM
  7. [SOLVED] Does anyone have a weekly schedule that computes total hours work
    By Guillermo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-03-2006, 01:10 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