Hi,
Could somene tell me if there is a way to sort a list of jobs that are required to be done over a monthly period (per day)
I have a list of tools and how many hours they have been used for, i'd like to be able to plan how many jobs i can do per day ( 3,4,5,6) is there a formula i can use that would automaticaly sort them then start filling in the next days jobs until the list if tools is complete?
Thanks
<tbody>
</tbody>
Could somene tell me if there is a way to sort a list of jobs that are required to be done over a monthly period (per day)
I have a list of tools and how many hours they have been used for, i'd like to be able to plan how many jobs i can do per day ( 3,4,5,6) is there a formula i can use that would automaticaly sort them then start filling in the next days jobs until the list if tools is complete?
Thanks
tool | hours | per day | 14/09/19 | 15/09/19 | 16/09/19 | ||||||||||||||
0457893 | -12 | 3 (changeable) | 0457893 | 4376203 | |||||||||||||||
0247584 | 16 | 0247584 | 2846729 | ||||||||||||||||
1498045 | 25 | 1498045 | |||||||||||||||||
4376203 | 33 | ||||||||||||||||||
2846729 | 43 | ||||||||||||||||||
<tbody>
</tbody>