-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,171
- Office Version
- 365
- Platform
- Windows
Welcome to the Board!
You haven't given us any idea of how your data is structured, but perhaps a COUNTIFS function will do what you want. You can count based on person, whether the date is withint the past 30 days, and whether or not the shift was over 12 hours.
See: https://exceljet.net/excel-functions/excel-countifs-function
You haven't given us any idea of how your data is structured, but perhaps a COUNTIFS function will do what you want. You can count based on person, whether the date is withint the past 30 days, and whether or not the shift was over 12 hours.
See: https://exceljet.net/excel-functions/excel-countifs-function
Upvote
0
