Replies

Steve, Hans
Many thanks for helping out here. Steve your formula worked great. I am going to re design the workbook, I’ve complicated things somewhat in adding to it.

Regards
AJM

a + This example is for the boss. He is normally ‘office hours’ only (AD hours) but has to cover the ‘Workers’ who work a 24 hour shift roster (sick/leave cover), so any hours he works on the 24 hour roster including all overtime he gets paid an additional shift allowance (pay form 1943B) as the ‘worker’ get a shift allowance rate anyway as they on a 24 hour roster.
Spreadsheet works fine if my boss works whole shift on 24 hour roster or all office hours but it does happen that some of day is office hours and rest of day is shift hours hence pay form 1943B for those hours worked.

Hope this helps
Regards
AJM

Sorry for delay, posting this from work as was on sick leave.
Attached is sample
Thanks for looking at this.
AJM

Thanks Legare
Your guild worked a treat thanks
Andrew

Brent
Thanks a lot, that exactly what I was looking for. I can adapt that now. It was the SUMIF function I required.
Thanks for doing this
Andrew

I tried to modify from related post but got more confused. I think I am missing something simple, Will the IF function best fit my problem do you think?
AJM

thanks for the quick reply wassim, i will look at the work book & see.

I am running W2k. With IE5.5sp2 and Acrobat Reader 4.0, I was having the reported problems. Following your advice I installed Acrobat Reader 5.0 and am now a happy camper. I can now read PDF files directly as well as those that are embedded in script. Thanks.

PDF files won’t download automatically in 5.5sp2 or 6. Some PDF files will download if you R click them and use “save target as”. Others (I think their loacation is embedded in script) won’t download either way.