• WSandrewmac

    WSandrewmac

    @wsandrewmac

    Viewing 9 replies - 1 through 9 (of 9 total)
    Author
    Replies
    • in reply to: Counting (97now, soon 2003) #1019128

      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

    • in reply to: Counting (97now, soon 2003) #1019096

      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

    • in reply to: Counting (97now, soon 2003) #1019091

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

    • in reply to: is it paste special I need? (97) #936722

      Thanks Legare
      Your guild worked a treat thanks
      Andrew

    • in reply to: Formula request (Excel 97 & 2000) #931957

      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

    • in reply to: Formula request (Excel 97 & 2000) #931949

      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

    • in reply to: Alignment (exel 97 & 2000) #548639

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

    • in reply to: Manual Uninstall (IE5.5sp2) #545755

      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.

    • in reply to: Manual Uninstall (IE5.5sp2) #541475

      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.

    Viewing 9 replies - 1 through 9 (of 9 total)