Excel schedule with fraction of days

[Spencer0202]

I am trying to create a schedule in excel that will account for fractions of a day.

Column H is the task duration - Column I are my start dates - Column J are my end dates


task #1 takes .5 a day (.5 in cell H1) - start date is set at 4/18/22 (4/18/22 in cell I1) - What formula works for J1 so it ends up showing 4/18/22 but still accounting for half the day?
task #2 takes 2.75 days (2.75 in H2) - if I put (=J1) in cell I2 it just puts the start time for task #2 at the beginning of 4/18/22. It does not account for the .5 day from task #1. what formula works for I2 to incorporate the time spent on the previous task?
task #3 takes .75 days (.75 in H3) - J3 start date should be 4/21 because task 1 and 2 are 3.25 days so 18th is day 1, 19th is day 2, 20th is day 3. The .75 from task #3 means task #3 should end at the end of the day on 4/21, which is the 4th day from 4/18. And then task #5 would start at the beginning of 4/22/22

Not sure if it would help converting everything into hours and then count on a 10 hour work day so .1=1hr , .5=5 hours(half a day), ect. But we typically work 4-10hour shifts. I am factoring my TASK DURATION in days and fractions of days so I do not care about start time of working hours during the day (unless that needs to come into play for the formula someone provides, it does not matter to me)

I have been wasting so much time scouring these threads and trying to watch video playing with the workday, workdayint function. I saw one thread they were trying to calculate it as a SUM function but everything I have seen or tried has not worked and would not account for the fraction of the day before.

Any help on this would be extremely appreciated.

Thank you, Spencer

 

[Spencer0202]

Joe4, when I first made the post I was trying simplify it without having any pictures so disregard the first post, because it doesnt actually match what my picture shows.

I am trying to create a schedule in excel that will account for fractions of a day.


task #1 takes .5 a day (.5 in cell H2) - start date is set at 4/18/22 (4/18/22 in cell I2) - What formula works for J1 so it ends up showing 4/18/22 but still accounting for half the day? Right now I have the workday formula, and I tried doing it -1 which works if items are longer than 1 day, but when things take less than 1 day then it makes the end day on 4/17/22.


task #2 takes 2.75 days (2.75 in H3) - if I put (=J2) in cell I2 it just puts the start time for task #2 at the beginning of 4/18/22. It does not account for the .5 day from task #1. what formula works for I3 to incorporate the time spent on the previous task?
task #3 takes .75 days (.75 in H4) – J4 start date should be 4/21 because task 1 and 2 are 3.25 days so 18th is day 1, 19th is day 2, 20th is day 3. The .75 from task #3 means task #3 should end at the end of the day on 4/21, which is the 4th day from 4/18. And then task #4 would start at the beginning of 4/22/22

Not sure if it would help converting everything into hours and then count on a 10 hour work day so .1=1hr , .5=5 hours(half a day), ect. But we typically work 4-10hour shifts. I am factoring my TASK DURATION in days and fractions of days so I do not care about start time of working hours during the day (unless that needs to come into play for the formula someone provides, it does not matter to me)

Any help on this would be extremely appreciated.

Thank you, Spencer

 

[Joe4]

That gets really tricky when adding partial days/hours when work days are also involved.
I would take a look at the formula found in the "Add Number Of Business Hours To A Date With Formula" section here: How to add number of business/working days or hours to a date in Excel?

 

[mscleavite]

Spencer0202, did you ever get this figured out. I am trying to do something very similar

 

[ebea]

Is it something like this you have in mind. It's a bit difficult to follow your thoughts.

workdays-date.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1							0:00	24:00
2												18-4	19-4	20-4	21-4	22-4	23-4	24-4	25-4	26-4
3	12	1	EXC	task 1	8	500	1000	0,5	18-04-2022 00:00	18-04-2022 12:00
4	66	2	LAY	task 2	8	1375	500	2,75	18-04-2022 12:00	21-04-2022 06:00		X
5	18	3	B/F	task 3	8	375	500	0,75	21-04-2022 06:00	22-04-2022 00:00		L	L	L
6	60	4	SERV	task 4	8	10	4	2,5	22-04-2022 00:00	26-04-2022 12:00				B
7	156	5						6,5	26-04-2022 12:00	05-05-2022 00:00				S	S
8		6
9		7
10		8
11		9
12
13
14
15
16
Ark1

Cell Formulas
Range	Formula
J3:J7	J3	=WORKDAY(I3,INT(A3/24)+IF(TIME(HOUR(I3),MINUTE(I3),SECOND(I3))+TIME(MOD(A3,24),MOD(MOD(A3,24),1)*60,0)>$H$1,1,0),FERIEDAGE!$C$3:$C$8)+IF(TIME(HOUR(I3),MINUTE(I3),SECOND(I3))+TIME(MOD(A3,24),MOD(MOD(A3,24),1)*60,0)>$H$1,$G$1+TIME(HOUR(I3),MINUTE(I3),SECOND(I3))+TIME(MOD(A3,24),MOD(MOD(A3,24),1)*60,0)-$H$1,TIME(HOUR(I3),MINUTE(I3),SECOND(I3))+TIME(MOD(A3,24),MOD(MOD(A3,24),1)*60,0))
I4:I7	I4	=J3
A3:A7	A3	=H3*24
A9:A11	A9	=IF(H9>0,24*H9,"")