Figuring Overtime In Spreadsheet

When Doing A Employee Schedule The Spreadsheet Adds All The Hours For That Individual. What I Need It To Do Is To Determine The Amount Of Hours Over 40 And Not Display A Negative Number When Below 40 Hours.

Anybody?????

You might be able to try this:

Put any number in cell A1

Put this formula in B1:
=(A1>40)*(A1-40)

Does that help?

Regards,
Ron

WORKED IN YOUR EXAMPLE, WHEN I PLUGGED IN INTO MY SPREADSHEET IT DIDN'T WORK, CAME UP ZEROS.
THANKS FOR TRYING TO HELP.

bEN

does someone know how to create formulas to calculate time sheets? i have problems when i enter a time such as 7 am to 4 pm.