Forum Discussion
Number of Hours Available Included
Hi community, I need help on how to complete my task. I was a given a dataset where it displays the job start date and end date for each staff. However, the data does not consist of the dates in which they are free and are not given any projects.
Another thing is that each staff are supposed to work for 8 Hours each day. For example, from 18 January to 20 January, John works for only 3 Hours each day which means that John are still available for 5 hours more on these 3 days.
I want to create two new columns in which it shows the start date and end date of when they are not given any task and are free. For example, the staff Michael does not have tasks from 24 January to 28 January. The staff John are supposed to be available from 18 January to 24 January as he does not take up the whole 8 hours from 18 to 20 January.
In Michael’s scenario, I believe that there are additional calculations to be made since there are 2 jobs given to him which overlaps. So we’ll have to find the correct date for which Michael are not given any task.
The below table is what I hope to achieve where I can have some calculations in my measures instead of manually entering the date in which the staffs are not given any task.
Thankk you!
1 Reply
Hi Anonymous ,
Do you want to get the available hours for per staff? According to your provided info, I only see the date period which every staff work on different jobs, is there any table to record the working hours for per job per staff? So later we can calculate the available hours base on the previous info... What's the calculation logic to get the available hours of per staff? Could you please provide some raw data and expected result with special examples? Thank you.
Best Regards