Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Time Sheet and Me

  1. #1
    Guest

    Default

    I need help. Here is what I have:
    sheet1 has 27 lines,
    Column (A) has the dates: (5 workdays).
    Column B has codes for the different task accomplished that day. I only need threes of the 12 codes.
    Column c has the hrs worked that day.
    I need a formula that will look at each day and find one of the three different codes for that day. If the code is there I need the hrs for that code on page to sheet02.
    this is part of a formula I use on sheet2:
    =if(sheet01!b6=31,e6,if(sheet01!b6=32,e6,if(sheet01b6=33,f6),"").
    What this formula is saying is:
    If on sheet01 column b6 has either one of the three codes 31,32, or 33 to display the hours in e6.

    also, I need a way to take some of the IF statments out, whichever code is true to display the hours in E6.

    I will email you what I have if need be, if I can get some help or explain further, in a longer email.
    Thank

    By the Way Mr. Excel, I tried to edit my posting of Dating and ???? sheet. But I did not know how to delete it. So I posted a new one. Forgive me. New to this posting thing.
    Walter

  2. #2
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,853
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    To get arount the Ifs you could use Vlookup.

    Hopefully this will point you in the right direction.

    HTH

    DRJ


  3. #3
    Guest

    Default

    DRJ
    I am in the process of trying the vlookup table NOW.
    But I still have NOT gotten any help with the rest of my problem,
    Walter

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •