overtime templates
Can anyone help?
I am trying to produce and overtime sheet which covers an entire month period. The columns consist of date, day of week, start and finish times and total hours worked. There is also a cell that contains the daily contracted hours which is used to help calculate the overtime hours worked (if any) for that day. The calculations works fine for the week days but on the Saturday and Sunday (non working days) it treats the day as a normal working day and produces overtiem hours for a Saturday as if it was a normal week day. Does anybody know what formula can be entered in the cells that will sum up the total hours worked for any day, but in addition differentiate between a normal week day and a Saturday and Sunday, then return the full overtime hours for that day. Hope you can help |
http://www.cpearson.com/excel/overtime.htm
-- Kind Regards, Niek Otten Microsoft MVP - Excel "Flash" wrote in message ... Can anyone help? I am trying to produce and overtime sheet which covers an entire month period. The columns consist of date, day of week, start and finish times and total hours worked. There is also a cell that contains the daily contracted hours which is used to help calculate the overtime hours worked (if any) for that day. The calculations works fine for the week days but on the Saturday and Sunday (non working days) it treats the day as a normal working day and produces overtiem hours for a Saturday as if it was a normal week day. Does anybody know what formula can be entered in the cells that will sum up the total hours worked for any day, but in addition differentiate between a normal week day and a Saturday and Sunday, then return the full overtime hours for that day. Hope you can help |
All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com