Hi everyone, i was hoping someone would be able to help me with the following problem..
I have one field which is called Operation Area - for example Electrical, Engineering, Office etc
Then a start date and end date - how long the job is estimated to take
Plus an estimated hours field - how many hours needed complete the job
I need to divided the amount of working days between the start and end date by the estimated hours (which I have so far only worked out how to do in a form, since as far as i know calculating working days is not possible in a table?)
I would like to have a some sort of calendar or a just a list day by day of how many hours work there is for each Operation area.
For example the table looks like this
Operation Area Start Date End Date Estimated Hours
Electrical 1/1/13 2/1/1 10 hours
Office 1/1/13 2/1/1 6 hours
Engineering 1/1/13 2/1/1 16 hours
But i would like to have a report that does this
Date Electrical Office Engineering
1/1/13 5 hours 3 hours 8 hours
2/1/13 5 hours 3 hours 8 hours
Is this possible? I get stuck where I need to divide the hours up over the start to end date and show that