I am trying to create a timesheet that gives overtime daily over 8 hours and also over 40 hours per week. What kind of formula can I use for this?
Monday - 0 hours
Tuesday - 13.25 (8 Reg, 5.25 OT)
Wednesday - 12.5 hours (9.25 Reg, 3.25 OT)
Thursday - 20.25 hours (8 Reg, 12.25 OT)
Friday - 2.25 hours (2.25 Reg)
Saturday - 13.5 hours (8 Reg, 5.5 OT)
Sunday - 10 hours (4.5 Reg, 5.5 OT)
I have this formula for the weekly, but I need one for the daily:
=IF(G19>40, 40,G19)
Thank you!!
Here's a free Timecard calculator with options for daily overtime and weekly overtime builtin, downloaded from Vertex42.
_________________
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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks