•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Building a rota where it calculates total hours
Our take
Hello! It sounds like you're embarking on a valuable project to streamline your department’s scheduling. Creating a rota that totals hours worked, including separate calculations for AM and PM shifts, is definitely achievable, even for a novice. You can set up a simple formula to sum the hours while excluding terms like "OFF" or "HOLIDAY." This approach will help you efficiently track weekly totals across all seven days. Let's explore how you can implement this solution and simplify your workflow. Cheers!
Hello!
I’m building a rota for my department of 3.
I want to be able to total up the amount of hours worked in a week.
I need a sum that will:
Work out an AM call and PM call
Add these together
Add 7 days worth today
ALSO ignore words within the sum (for example, OFF or HOLIDAY)
Let me know if it’s possible! I’m a complete novice.
Cheers!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#rows.com#Excel compatibility#Excel alternatives#rota#total hours#AM call#PM call#sum#worked#calculate total#week#7 days#add together#hours worked#ignore words#OFF#HOLIDAY