View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tammy Tammy is offline
external usenet poster
 
Posts: 145
Default Payroll labor costs

I don't believe a simple SUM would work. For each employee I input their
schedule by day. I want to type in i.e. 10:00 AM to 4:00 PM and have excel
calculate the hours worked times their rate of pay (also calculate OT if
applicable). The end result should one dollar figure that indicates the
overall labor cost for all employees for each week.

"Bearacade" wrote:


It depends on how you set up the schedule, should it be a simple SUM?


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=558530