Computer Forums Needing Excel timecard template help

 07-02-2012, 02:44 PM #1 Wizard of Wires     Join Date: Feb 2005 Location: Not sure Posts: 10,030 Needing Excel timecard template help I need a template to calculate hours and overtime hours based on a 40 hour week. The catch is not to start calculating overtime until 40 hours normal time has been reached. The routine here where I manage has been when our relief is not in town the 3 office workers have to work 7 days a week for several weeks at a time. Since we went on a check based payroll system, they have been calculating overtime pay and it's out of this world. What I'm wanting to do in a nutshell is show the owner it would be far more cost effective to bring a floater onboard. Someone that would be trained on all 3 shifts and give us some time off. You get real stressed out if you keep that sort of load up for weeks at a time. So it would solve 2 problems with 1 extra person. OK, enough of that. The end goal is to show, in dollars spent, that it would be smarter to go ahead and hire someone. When you shove a spreadsheet under someone's nose and in hours and minutes along with dollars and cents, that they could save X amount of money in a given time frame. Along with our sanity... Any ideas? __________________ __________________
 07-02-2012, 09:15 PM #2 Fully Optimized     Join Date: Mar 2011 Location: USA Posts: 2,099 Re: Needing Excel timecard template help A formula such as Code: `=IF(SUM(B3:F3)<=40,SUM(B3:F3)*K3,40*K3+(SUM(B3:F3)-40)*1.5)` where the cells B3 thru F3 contain the daily hours and the cell K3 contains the hourly rate should do the trick. If the total hours worked in the week are 40 or less then multiply total hours worked by the hourly rate. If total hours is greater than 40, then subtract 40 from the total hours worked, multiply that by 1.5 and add to the hourly rate times 40. __________________ __________________
 07-03-2012, 11:56 AM #3 Wizard of Wires     Join Date: Feb 2005 Location: Not sure Posts: 10,030 Re: Needing Excel timecard template help Excel Timesheet Templates - Free employee timesheet templates The one for overtime based on an 8 hour day. __________________