Thank you so much, Peo!!!! I could hug you right now.

"Peo Sjoblom" wrote:

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






"Sandra" wrote in message
...
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