calculate regular earnings seperate from OT
RE Excel 2007
I'm looking for a formula to calculate only the regular rate of pay for 8 hours or less. If the hours worked is more than 8, I'd like only the pay for 8 to be calculated. (The overtime hours and pay will show in other colums and I've figured them out)
EX: column a is 12 hours worked, b is regular rate $10.00, c is regular earnings...Need formula
Thanks for any help!
I would think:
=MIN(A1 * B1, 8 * B1)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Re: calculate regular earnings seperate from OT
Thanks! Works Great!
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks