i need to make a formula that adds up my hours after my 40 hours

[johnny rodriguez]

for example i put my hours daily but i need to have a formula that tells me
how many hours over time do i have after my 40 so the table automatic tells
me how much more money do i earned that week
example that i had already done b7-40*30.00 enter it works but not until i
make 40 hours
please help me if you can
thank you

[pinmaster]

Hi,
Try:
IF(B7>40,B7-40*30,"")

HTH
JG

[excelking54]

Ever heard of a calculator?

[Dave O]

Try changing your formula to
=IF(B7>40,B7-40*30,"")

The cell will be blank until you work more than 40 hours.

[exceluserforeman]

This problem is what Excel does best! If we all just used calculators,
Microsoft would go broke!

"excelking54" wrote:

>
> Ever heard of a calculator?
>
>
> --
> excelking54
> ------------------------------------------------------------------------
> excelking54's Profile: http://www.excelforum.com/member.php...o&userid=28348
> View this thread: http://www.excelforum.com/showthread...hreadid=479312
>
>

[Bryan Hessey]

or

=IF(B7>40,(B7-40)*30,"")

?

Try changing your formula to
=IF(B7>40,B7-40*30,"")

The cell will be blank until you work more than 40 hours.