Excel 2002 Formula

  • Thread starter Thread starter Emma
  • Start date Start date
E

Emma

I need an Excel formula that will calculate overtime. If
the amount in C6 is greater than 8 hours, I need the
amount over 8 hours to show in C8. Any help will be
appreciated. Thanks.
 
Emma,

Presuming you're using regular times (8:00:00) not plain numbers (8) for
your hours:

=MAX(C6-TIMEVALUE("8:0:00"),0)

If plain numbers:

=MAX(C6-8, 0)
 
for a report that I needed that had to detail the amount
of regular hours, overtime hours, regular pay, overtime
pay..

A1=hours
A2=rate

A3=reg '=IF(A1>8,8,+A1)
A4=overtime '=A1-A3

reg pay '=A2*A3
overtime '=(a2*1.5)*a4

assuming overtime is paid at 1.5 regular.
 
Back
Top