Spread Duration of Work, Over Days

[vijaykrrao]

Hello Excel Group!!!

This is my first post on this forum, seeking help.

I searched and went over many examples on this forum, none I could find which distributes over days.

I am trying to spread duration over the dates which fall between Start and Finish date of each task.
The "Start" & "Finish" date, can overlap last and first day of the month and month+1.
The "Work hours per day" is standard 8 hours, in some cases may be 4 hours (i.e. the task can be 4 hours or 8 hours).

Appreciate your help to resolve this problem, which I am trying to solve over 2 weeks now! Thanks in advance.


Here is the example in Xl2bb format:

Spread_Duration_Across_Days.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	Example:							Weekend
2	Name	Start	Finish	Duration	Work hours Per Day	27-May-21	28-May-21	29-May-21	30-May-21	31-May-21	1-Jun-21	2-Jun-21
3	John	27-May-21	2-Jun-21	40	8	8	8	0	0	8	8	8
4	Jack	28-May-21	31-May-21	12	8		8	0	0	4
5	Jack	31-May-21	2-Jun-21	20	8			0	0	4	8	8
Sheet1

Cell Formulas
Range	Formula
G2:L2	G2	=F2+1