Total Hrs Worked Reg Hrs Overtime 45 40 5 35 35 (what formula for this) 0
I have the OT column figured out but how do I get the Regular Hrs Column to give me 40 if there is overtime but the actual number if there is no OT or the number is under 40?
Thanks!
Regular Hours
=MIN(Total Hours Worked,40)
OT
Total Hours worked - Regular Hours
Last edited by JohnTopley; 09-24-2015 at 12:01 PM.
Thank you! That worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks