Computing Payroll Hours

[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

 

[Tom Ogilvy]

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+D221-C2:C21)*24

would give you the total hours.

 

[Herbie]

Thanks Tom,
your suggestions worked perfectly....
herbie