•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
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]
Want to read more?
Check out the full article on the original site
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