Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving templates with links and formulas | Excel Discussion (Misc queries) | |||
how do i add excel templates to spreadsheet solution | Excel Discussion (Misc queries) | |||
finding templates | New Users to Excel | |||
Paste Link and Templates | Excel Worksheet Functions | |||
IF or SUMIF help for Overtime Formula | Excel Worksheet Functions |