Shellis1969
New Member
Hello Everyone,
I am so happy to find such a great site as this. Looking to get help with allocating the total amount into daily column:
I have:
Start Date
End Date
Total Hours
Start HOURS - this is provided, and must be use on Start Date.
Remaining Hours - This is the Total Hours minus Start Hours
*Remaining Hours _ I need to prorate this Daily at 9 hours per day
If you look at the attached xls, This is ideally how I would like to see my workbook
Can someone recommend the appropriate formulas to calculate the daily Schedule?
Thanks!
I am so happy to find such a great site as this. Looking to get help with allocating the total amount into daily column:
I have:
Start Date
End Date
Total Hours
Start HOURS - this is provided, and must be use on Start Date.
Remaining Hours - This is the Total Hours minus Start Hours
*Remaining Hours _ I need to prorate this Daily at 9 hours per day
If you look at the attached xls, This is ideally how I would like to see my workbook
Can someone recommend the appropriate formulas to calculate the daily Schedule?
Thanks!