use results from filtered table
Hi,
I’m using a spreadsheet to monitor staff clock in and out hours across various properties. We use Bright HR, which allows us to export a csv for each week, from which I copy and paste the columns showing name, date, property where they were working, and the amount of hours for each week.
I have set the table up so I can filter via name. This will allow me to see each caretaker’s hours worked. I then need to be able to see if their total cumulative hours are above or below the set amount of hours we allocated for that property.
For example, If Duane works at property A, and Property A has 20 hours a week allocated to it, and Duane has done a cumulative 48 hours for that month, then I need to be able to see how many hours Duane is short, and how many hours he owes us.
This needs to be cumulative across the year, so I can just add the hours each week to my base table, and have a different sheet display the amount of hours along with the caretaker’s name, amount of hours done, how many hours should have been done, and any difference in those totals.
Any help would be appreciated!
Hi, I’m using a spreadsheet to monitor staff clock in and out hours across various properties. We use Bright HR, which allows us to export a csv for each week, from which I copy and paste the columns showing name, date, property where they were working, and the amount of hours for each week. I have set the table up so I can filter via name. This will allow me to see each caretaker’s hours worked. I then need to be able to see if their total cumulative hours are above or below the set amount of hours we allocated for that property. For example, If Duane works at property A, and Property A has 20 hours a week allocated to it, and Duane has done a cumulative 48 hours for that month, then I need to be able to see how many hours Duane is short, and how many hours he owes us. This needs to be cumulative across the year, so I can just add the hours each week to my base table, and have a different sheet display the amount of hours along with the caretaker’s name, amount of hours done, how many hours should have been done, and any difference in those totals. Any help would be appreciated! Read More
