# Summing Hours Worked by User and Pay Period
**URL:** https://community.glideapps.com/t/summing-hours-worked-by-user-and-pay-period/66547
**Category:** Ask for Help
**Created:** [September 26, 2023, 8:13pm UTC](https://community.glideapps.com/t/summing-hours-worked-by-user-and-pay-period/66547 "2023-09-26T20:13:16Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@BobbyG77](https://community.glideapps.com/u/BobbyG77)
#### Post date: [September 26, 2023, 8:13pm UTC](https://community.glideapps.com/t/summing-hours-worked-by-user-and-pay-period/66547/1 "2023-09-26T20:13:16Z")
I have an app that enables technicians to enter their hours in the field. It sits on top of an Airtable base. Once the user makes a timesheet entry, my app shows the timesheet entries only for that user, grouped by pay period (which is week of the year). I’m trying to add to that screen to show the sum of hours entered for each pay period. Suggestions?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 27, 2023, 1:23am UTC](https://community.glideapps.com/t/summing-hours-worked-by-user-and-pay-period/66547/2 "2023-09-27T01:23:31Z")
- Create a query in the timesheet table, set the filter to userID equals to this row \> userID and pay period equals to this row \> pay period.
- Create a rolllup column on top of that query, sum the hours.
- Create a template column to combine the pay period and the sum above. E.g: Week 1 - 2023 - 20 hours.
- Group your collection by that template column.
---
### Author:  [@BobbyG77](https://community.glideapps.com/u/BobbyG77)
#### Post date: [September 27, 2023, 7:24pm UTC](https://community.glideapps.com/t/summing-hours-worked-by-user-and-pay-period/66547/3 "2023-09-27T19:24:48Z")
Thank you sir! Will give it a shot.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 28, 2023, 12:14am UTC](https://community.glideapps.com/t/summing-hours-worked-by-user-and-pay-period/66547/4 "2023-09-28T00:14:25Z")
Please let me know if it works, or you need any further adjustments!