Hi everyone, I am hopeful you can help me

I have 6 time buckets for 6 operations. If some of the operations are done on the same day, I would like to split the 8 hour work day into how many operations are done in the same day. If I use use the networkdays function, it would create 1 day for each function. So for example. I wash my clothes (operation 1), Dry my clothes(operation 2), Iron my clothes(operation 3, Hang my clothes(operation 4) all in the same 8 hour workday. simple enough to divide by the amount of operations in that day....right? but sometimes I don't iron or hang the clothes in the same day.

Example 1
1/4/2022 - Wash Clothes
1/4/2022 - Dry
1/4/2022 - Iron
1/4/2022 - Hang
I should get networkday of 1 day in total

Example 2
1/4/2022 - Wash Clothes (considered 1 day in total with below)
1/4/2022 - Dry (considered 1 day in total with above)
1/8/2022 - Iron (Considered 4 days from above)
1/10/2022 - Hang (Considered 2 daysfrom above)
I should get a networkday of 5 days in total
Please help
Thanks
Dean

Hello DeanV2,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.