Hi all,

i have a task list with
  • hours
  • start date
  • finish date
In columns a, b and c

In row 1, from D1:AK1 i have dates as table headers.

Below these dates i would like to calculate the hours scheduled for the task described on that row.

Eg a task starting may 1st, ending may 3rd, 3 hrs work.

I would like to see 1 hr under may 1st, may 2nd and may 3rd.

I had this formula calculated myself some time ago but have mislaid it, and it has been some time since i've used excel in anger!