Time Card Help

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

Guest

I'm creating a time card for my office. My problem is that I created a single
box to to hold the amount of any overtime past 40 Hrs only.
I'm not concerned with overtime past 8 hours daily because like most
companies ours only pays past 40 hrs weekly.
Can you please help me with this formula?
I'm using Pro Edition 2003 Excel
 
You can use

=MAX(SUM(E2:E8)-"40:00",0)


where E2:E8 holds the daily hours

if you have the total in a single cell you can use

=MAX(F6-"40:00",0)


will return hours over 40


multiply result with 24 and format as number if you need decimal value for
calculating rates


--


Regards,


Peo Sjoblom





--


Regards,


Peo Sjoblom
 
Back
Top