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