Forum Discussion
Solved
Setting up a "smart" count for a column for overtime
I am trying to set up a totaling function for regular and overtime in a column. Here is the catch: Over time is met at 8 hours a day AND whenever the employee hits 40 hours in a week. I can run a for...
Here is a solution that calculates overtime using a custom VBA function. Regular time is calculated as total time - overtime.
loganak Have a look at the attached file. It contains two possible ways to calculate this. Choose the one that works in your Excel version.
Sometimes the best answer is a simple one. I think this will work for what i'm trying to achieve.. my first attempts were multiple nested =IF statements combined with MAX mixed in haha. Thank you for the insight!
- my only caveat; finding that regular time value from a formula. Hand calculating it adds a substantial amount of time to payroll by the number of employees in the company
Here is a solution that calculates overtime using a custom VBA function. Regular time is calculated as total time - overtime.
- That is the one thing I haven't spent much time with. I used to be a matlab guy so I need to learn some more in the VBA side of excel. I really appreciate it!