Payroll formula

[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.

 

[Frank Kabel]

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

 

[Gord Dibben]

Dak

Have a look at Chip Pearson's site on timesheets/overtime.

http://www.cpearson.com/excel/overtime.htm

Gord Dibben Excel MVP