Gantt Chart showing tasks in 1/4days using conditional formatting

[HighlandRanger]

Using WORKDAY.INTL to be able to hide weekends and holidays, is it possible to display upto 2 months and use conditional formating to show a gantt chart with days divided into 1/4s? I have presented a table with one week to show an example.

					22				23				24				25				26
FEATURE	BACKLOG ITEM	Effort	Start Date	End Date	M				T				W				T				F
Parent Task		4.75	2/22/21	2/26/21
	Child Task 1	1	2/22/21	2/22/21
	Child Task 2	0.25	2/23/21	2/23/21
	Child Task 3	0.5	2/23/21	2/23/21
	Child Task 4	1	2/23/21	2/24/21
	Child Task 5	0.5	2/24/21	2/25/21
	Child Task 6	0.5	2/25/21	2/25/21
	Child Task 7	1	2/25/21	2/26/21

 

[HighlandRanger]

I spend a while trying to get it working - and it always had some kind of weirdness. I couldn't get it to work.

I custom VBA function would have to come into play here.

I think I'm getting somewhere with your original... however, I noticed something weird.

Check out the first PROJECT TASK. If I make the EFFORT "7" then it takes the graph from 2/22 to the end of 3/2 (7 whole days) as expected
But if I make the EFFORT "7.25" it takes the graph back to 3/1 - 5 whole days and .25 of 3/1

Using this calculation in the END DATE =IF(OR(WEEKDAY(start_date+effort-0.25)=7,WEEKDAY(start_date+effort-0.25)=1),start_date+effort-0.25+2,start_date+effort-0.25)

Any clue what the issue is? It seems like it's adding the weekend back in?

 

[HighlandRanger]

See this thread, its on a hourly gantt time chart, might give you some idea, as your are doing days in portions Mr Excel

Thanks, but that doesn't allow for projects that go past weekends and holidays. I think we are currently on the right track here, if I can figure out the anomoly I just found.