Question about Business & Productivity Software
I have to calculate weekly overtime, anything over 48 hours, but the same time, if an approved leave is there, OT will be counted, similarly un approved leave , i.e. Absent, OT will not be counted.
I hve to calculate monday to saturday. 8 hours is the single working hours. Can anybody help me. email@example.com
Posted on Apr 13, 2009
The formula should go like this:
This one will give you the result of (ONLY overtime hours)*(hourly wage), and if there are no overtime hours the result is 0.
Now, if you need to multiply that result with say 1,5 or whatever - insert the number you need like this:
If you need more help, please ask.
Posted on Sep 15, 2008
Tips for a great answer:
Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...
Sep 20, 2008 | Microsoft Business & Productivity Software
Aug 30, 2008 | Microsoft Excel for PC
Apr 04, 2008 | Microsoft Excel for PC
Nov 29, 2016 | Toshiba Business & Productivity Software
695 people viewed this question
Usually answered in minutes!