how to calculate overtime automatically on Excel timesheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate overtime at 2 different rates 5
overtime calculation 3
Calculating timesheet with overtime 2
Overtime Calculations 1
Sum of Daily Overtime 10
Creating an Excel Database for my Logged Time 2
Overtime Calculation for Overtime 4
Calculating regular time, subtracting any personal time 5

Back
Top