Say we have data that looks like this
- Project, start date, end date, Total hours
- Task A, Jan 2023, June 2023, 50
- Task B, Feb 2023, July 2023, 100
If we assume a smooth work schedule where work to be done in a month for a project is total hrs/number of months. How can i lay this out, so we know how many hours of work needs to be done in a given month?
In the above example, it would be 150 hrs/6 months, so 30 hrs a month of work to be done.