• Formula request (Excel 97 & 2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Formula request (Excel 97 & 2000)

    Author
    Topic
    WSandrewmac
    AskWoody Lounger
    February 26, 2005 at 8:14 am #416384

    Hello. I am hoping to use excel for an attendance register at work and count up everyone’s hours/shift etc. I am looking for a formula that will recognise what sort of shift someone has worked. In say cells C2:C9 I have the type of shift for each day of that week , D for day shift, N for night shift, AL for leave etc etc. and in D2:D9 I have the hours worked for that shift pattern. I then have the same in F2:F9 for the following week. A month per worksheet.
    Below all this I hopefully would like a formula that would be able to search/lookup each weekly column to give the total hours associated to each shift type. D shift 27 hours, AL 8.5 hours, Admin 8 hours etc.
    Hope I explained thinks OK if not I can supply more info, hopefully.
    Cheers compute

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSsdckapr
      AskWoody Lounger
      February 26, 2005 at 10:51 am #931307

      (Edited by sdckapr on 26-Feb-05 06:51. Changed post with code to the updated version)

      I think your question is very similar to post 380774 and you might be able to adapt the solutions found in that thread. The most pertinent is probably the function in post 380915 which could be modified to your specific needs.

      Steve

      Reply | Quote
      • WSandrewmac
        AskWoody Lounger
        March 1, 2005 at 9:47 pm #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

        Reply | Quote
        • notbrl
          AskWoody Lounger
          March 1, 2005 at 10:05 pm #931954

          AJM,

          How bout something like this…

          Brent

          Reply | Quote
          • WSandrewmac
            AskWoody Lounger
            March 1, 2005 at 10:11 pm #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

            Reply | Quote
            • notbrl
              AskWoody Lounger
              March 1, 2005 at 10:36 pm #931960

              Andrew,

              Never a problem. This is a great place. Someone will come up with an answer or two for most any question. Usually it is a race to get your reply in before someone else beats you to it. When I have a question or need advice for a problem I am working on, this is the first place I look to.

              Brent

              Reply | Quote
    Viewing 0 reply threads
    Reply To: Formula request (Excel 97 & 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.