how do I set up time worked in excell spreadsheet
 

I need to set up a spreadsheet to computer overtime. Each person work 37.50
hours a week. Listing in, out toltal hrs. worked minus scheduled hours (7.5)
per day we have to get 40 hrs before the overtime and last the OT hours

how do I set up time worked in excell spreadsheet
 

Look he

http://www.cpearson.com/excel/overtime.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"jdavis614" wrote in message ...
|I need to set up a spreadsheet to computer overtime. Each person work 37.50
| hours a week. Listing in, out toltal hrs. worked minus scheduled hours (7.5)
| per day we have to get 40 hrs before the overtime and last the OT hours