how do I set up time worked in excell spreadsheet

[jdavis614]

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

 

[Niek Otten]

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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