hour sum setup

[Guest]

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

 

[Andy B]

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.

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.