how to calculate overtime automatically on Excel timesheets

J

Jeanine

Does anyone know how to make an Excel spreadsheet calculate overtime
automatically? I have it set up to calculate how many hours each person
worked subtracting out time for lunch. How do I get it to read that if the
hours in the regular hours column is over 8 a day, to put the difference in
the overtime field?

Thank you.
 
B

Bob Phillips

Use a formula like

=MAX(0,H1-8)

where H1 is the hours worked.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top