how do I set up time worked in excell spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jdavis614 - 21 Apr 2007 19:56 GMT

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

Reply to this Message

Niek Otten - 21 Apr 2007 20:07 GMT

Look here:

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

Signature

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

Reply to this Message