Need Help In Developing a Customized Time Sheet and Summary

**akbar** · 04-11-2013, 08:05 AM

Dear All ,

Please find the attached file.

It seems little bit complicated but if somebody can simplify it then it would be appreciated.

1.On Man' work sheet I Have a Project No (actual one is a big one) and project code,i have made the project code because it cannot
be entered on the time sheet as the original project no is very big and i have legends,then Empl nos and OT Rates

Now on the time sheet if i enter the Project Code A to C it should be counted as "P" present for work, rest as usual.

2.On Summary' work sheet Columns D to J should calculate it automatically based on employee no or name and Project No.

Any Ideas will be appreciated.

Thanks,
Ak

**dilipandey** · 04-11-2013, 08:14 AM

Hi Akbar,

Now on the time sheet if i enter the Project Code A to C it should be counted as "P" present for work, rest as usual.

I did not found time sheet .. please check.

Also, can you enter some of your expected results manually and then I'll try to obtain them using formulas.. thanks.

Regards,
DILIPandey
<click on below * if this helps>

**akbar** · 04-11-2013, 08:28 AM

Hello Dilip Please find the attachment, Man' worksheet A3:L8 is the sample time sheet and results can be found in
Summary work sheet filled with yellow color.

Thanks,
Ak

**dilipandey** · 04-11-2013, 10:02 AM

Hi Akbar,

I did not found "p" in row 4 of Man sheet but look into the attached worksheet where I used below formula:-

Formula:

=SUMPRODUCT((data="A")*1)

where data is a defined name , press ctrl + F3 to see the logic used in this name..
New Microsoft Office Excel Worksheet(1).xlsx

Regards,
DILIPandey
<click on below * if this helps>

**akbar** · 04-11-2013, 03:15 PM

Hello Dilip when ever a project code is given in the cell then it should be considered as the employee is present at that project that's what i meant.
value displaying on summary worksheet D4 is correct,but i dont know how it is working and logic behind that.

Could you please explain little bit.

Thanks,
Ak

**Roger Govier** · 04-15-2013, 07:28 AM

Take a look at the reply given at your Crosspost in the Codecage

**dilipandey** · 04-12-2013, 08:21 AM

As I mentioned in my previous post :-

where "data" is a defined name , press ctrl + F3 to see the logic used in this name..

Also, search internet for video tutorials on Sumproduct function to learn about this function.

Row 4 of "man" sheet has project codes and legend codes both - and this is creating confusion.

Regards,
DILIPandey
<click on below * if this helps>

Need Help In Developing a Customized Time Sheet and Summary

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Need Help In Developing a Customized Time Sheet and Summary

Re: Need Help In Developing a Customized Time Sheet and Summary

Re: Need Help In Developing a Customized Time Sheet and Summary

Re: Need Help In Developing a Customized Time Sheet and Summary

Re: Need Help In Developing a Customized Time Sheet and Summary

Re: Need Help In Developing a Customized Time Sheet and Summary

Re: Need Help In Developing a Customized Time Sheet and Summary

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions