I have an export from Redmine EasyGantt which I'm trying to paste into project.
For each task, I have resource name, start date, finish date and expected task-hours. The hours don't always come to the max number of available hours in a day.

For example, a task may run from June 1st to July 1st, and have 40hrs allocated to it.

I need to divide those hours evenly across each working day between the start and finish dates (approx. 2hrs / day in the above case).

The resource name will also be pasted-in, and must be assigned a % load based on the hours per day for each task, so that I can see where each resource is overloaded.

Tasks may overlap, obviously, and each resource may spend 2hrs on one task, 3hrs on another and so on each day.

How can I do this?
thanks
Guy