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 whic...
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