Time Card Help
 

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

Time Card Help
 

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

Time Card Help
 

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

Time Card Help
 

Thanks for the feedback and the hug :)


--


Regards,


Peo Sjoblom



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