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.
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!