Hello All,
I am just trying to figure out what my own paychecks will be. The only problem is that I am doing a lot of overtime (time and a half) and I am looking for a formula that will stay at zero until I go over 40 hours.
Hello All,
I am just trying to figure out what my own paychecks will be. The only problem is that I am doing a lot of overtime (time and a half) and I am looking for a formula that will stay at zero until I go over 40 hours.
The if function should be able to do this:
=IF(hours<40,hours*standard_rate,40*standard_rate+(hours-40)*overtime_rate))
Mark
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks