Help with list.accumulate

[aaron lowrey]

I have a table with dates in a power query column for multiple projects. The table has dates between the start date and end date that have been filtered to exclude weekends and holidays. So I have functional work dates.

I would like to add a column to this table with prorated working hours for each day. For example, If I have 22 hours, I would like to place 8 hours for each day until I have less than 8 hours and then place the remainder in the last day .

I tried several guesses with using list.accumulate to make the hours list and am getting nowhere. Would any one know of a good reference for something like this?

 

[GraH]

Cross-posted here

Aggregate a value across dates in a table

I'm attempting to find a way to aggregate a value across several dates. I have a set of hours for projects that I am wanting to split up between all the dates for that project. I've been able to work out work days including holidays in a table column. I would like to use some function like...

chandoo.org

 

[aaron lowrey]

Cross-posted here

Aggregate a value across dates in a table

I'm attempting to find a way to aggregate a value across several dates. I have a set of hours for projects that I am wanting to split up between all the dates for that project. I've been able to work out work days including holidays in a table column. I would like to use some function like...

chandoo.org

Thank you for catching my cross posting.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.