Time Sheet and Me

G

Guest

Guest
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
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
To get arount the Ifs you could use Vlookup.

Hopefully this will point you in the right direction.

HTH

DRJ
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,245
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top