Hours to complete a task put into the correct week from start and end dates.

[RichFer]

Hi all,

I have came to another stumbling block.

If i know the number of hours to complete a task. i.e 80 hours. The start date is 01/12/2023 08:00 and the end date is 15/12/2023 11:00, as you can see this will happen over several weeks. Is there a way to get excel to put i.e 38 hours week one from the 01/12/2023 8:00 - 07/12/2023 04:30, 38.5 hours week 2 from 08/12/2023 07:30 - 14/12/2023 04:30, 3.5 hours week 3 from 15/12/2023 07:30 - 21/12/2023 11:00. Also if there are holidays in a particular week, take these into account.

Many thanks in advance.

Rich