David Lam
New Member
Attached is a spreadsheet I have made up. I feel like I have over complicated my formulas.
Basically it must follow the rules below:
If someone works between 7am to 4pm they get $140 per hour less breaks
If someone works before 7am or after 4pm they get $185 per hour less breaks
I don't know when they will take their break so I have added a manual column for manager so to say to review and approve. Sounds easy right?
Well I have nested my formulas quite deep. It's very long.
Could another professional here give me feedback or another way to attack this?
I am here for my own professional development. I like to keep a open mind.
It works but I want to see how someone else will create their own formula.
Basically it must follow the rules below:
If someone works between 7am to 4pm they get $140 per hour less breaks
If someone works before 7am or after 4pm they get $185 per hour less breaks
I don't know when they will take their break so I have added a manual column for manager so to say to review and approve. Sounds easy right?
Well I have nested my formulas quite deep. It's very long.
Could another professional here give me feedback or another way to attack this?
I am here for my own professional development. I like to keep a open mind.
It works but I want to see how someone else will create their own formula.
