•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