If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
hour sum setup
i am currently trying to write an automated wage sheet for my temporary workers. i have finished the sheets and most of the formulas, however i am stuck. if the temporary worker works more than 39 hours per week thay go into time and a half, this is pretty straight forward, the problem is that if they work past 2 in the morning they get night rate, so the hours they work needs to be split up into the different columns. e.g.
they worked: Monday - 8 hours Tuesday - 12 hours (at Night Shift rate) Wednesday - 8 hours Thursday - 8 hours Friday - 11.5 hours (at Night Shift rate) These hours would then need to be split into the following boxes: Basic - 24 hours Night Shift - 15 hours Night Shift time and a half - 8.5 hours any help with this will be very much appreciated |
#2
|
|||
|
|||
hour sum setup
Hi
It depends how your data is laid out as to the best solution. Have a look here for some ideas: http://www.cpearson.com/excel/overtime.htm -- Andy. "andy" wrote in message ... i am currently trying to write an automated wage sheet for my temporary workers. i have finished the sheets and most of the formulas, however i am stuck. if the temporary worker works more than 39 hours per week thay go into time and a half, this is pretty straight forward, the problem is that if they work past 2 in the morning they get night rate, so the hours they work needs to be split up into the different columns. e.g. they worked: Monday - 8 hours Tuesday - 12 hours (at Night Shift rate) Wednesday - 8 hours Thursday - 8 hours Friday - 11.5 hours (at Night Shift rate) These hours would then need to be split into the following boxes: Basic - 24 hours Night Shift - 15 hours Night Shift time and a half - 8.5 hours any help with this will be very much appreciated |
Thread Tools | |
Display Modes | |
|
|