Time Card Help

[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

 

[Peo Sjoblom]

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

 

[Guest]

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

 

[Peo Sjoblom]

Thanks for the feedback and the hug


--


Regards,


Peo Sjoblom