Computing Payroll Hours

  • Thread starter Thread starter Herbie
  • Start date Start date
H

Herbie

I am using Excel 97, and would like to know how I can total payroll hours
daily, for my employees. Each day they punch in in the morning then out
for lunch....then again punch in after lunch and finally out at the end of
the day.... as you can tell I am not very good in Excel. Any help will be
appreciated... thanks,,,,, Herbie
 
if the times are in A1, B1, C1, D1 respectively and the hourly rate is in
E1, in F1 you can put

=(B1-A1+D1-C1)*24*E1

then you can sum column E

Time is stored as a fraction of a day. So multiplying by 24 converts the
time values to decimal hours.

assume you have 20 employees and times are in column A, B, C, D as specified
above, but in rows 2 to 21

=SUMPRODUCT(B2:B21-A2:A21+D2:D21-C2:C21)*24

would give you the total hours.
 
Back
Top