Payroll formula

  • Thread starter Thread starter Dak
  • Start date Start date
D

Dak

I want to create a workbook that will automatically calculate payroll
and overtime dollars when only hourly rate and total hours are listed.

Thanks in advance.
 
Hi Dak
1. Payroll dollars:
=A1*24*hourly rate
where A1 stores your total hours.

2. Overtime: as I don't know at which duration overtime starts lets
assume 8 hours.
try
=IF(A1>TIMEVALUE(8,0,0),(A1-TIMEVALUE(8,0,0))*24*overtime_rate,0)
where A1 stores your total hours.

Frank
 
Back
Top