Search results

got it......but how can i join the formula to extract data from all the sheet...

https://www.dropbox.com/s/tx7ddtvg6tngnl7/Tracker%202012%20-%202013.xls This is the origional XLS file that i have. I tried but failed to get the answer with these multiple sheets of the file...please help. I want all the sheets, staffs to be included.

Thanks ...but why is it still extracting SDO for 80740, Kumar Udas.....

Solved

Thank you so much ...... :)

https://www.dropbox.com/s/zbzyneqlu8d9xhg/Atten.xls this is the portion of the data that i have extracted from my origional.....

I have checked it out but the formula is checking from the top to 180 days, i want the formula to extract from the latest date to 180 days above, i.e if today is the date and so on. it extract all the SL and UL from today to 180 days above. Thanks again for all these help..... :)

Its the same related to above, the system i am using is generating these value in Excel format. I just want to find out the difference which you all have provided the solutions. Just want to find out how many extra hours the staff has worked. Check in time 6:00 AM Check out time 18:75 PM...

One more question....... 6:00 AM 18:75 PM, if the normal working hour is 8 hours, now how do i calculte the extra overtime hour he has worked....

Thanks everyone you all are great..... :)

https://www.dropbox.com/s/8q1ntyn0tdwj96m/Attendance%20sheet%20%281%29.xlsx I have made some common changes and the formula is not working, can you tell me why? and send me the solution too. I have made changes in some of the upper cell and add in new one too. I am very thankful for all your help.

Thank you Sir JB, Does anyone have a solution...

6:00 AM 14:00 PM result #VALUE! 6:00 AM 2:00 PM result 8:00 but the program that i am using is extracting the time format as in first row so when i subtract it shows #Value! sorry for the 2:00 AM and 14:00 PM, i post it wrong...... :)

janak 81135 santosh 81136 sanjay 81137 preeti 81138 manisha 81139 manisha 81140 jaya 81141 mahesh 81142 mohan 81143 dawa 81144 danny 81145 deepak 81146 dinesh 81147 Is there any way so that when we type in da, it shows only the name related with da i.e dawa, danny etc and so...

Dear Jeffrey i tried but its worthless cause the 2nd time formate is in 14:00 PM insted of 2:00 PM. More help please

Can we subtract 10:00 AM and 14:00 PM..... any one?

You are always helpful, Thanks for this awesome solution. Still i have something to ask...can we make the formula so that it can only search from the current date upto 190 days above.I.e 26 weeks rolling period. We update the attendance everyday so the formula should look at the latest date and...

Can anyone help to solve this problem...... :)

I just need to extract the following Week 6 4-Feb-13 SL Week 6 5-Feb-13 SL Week 16 13-Apr-13 SL Week 16 12-Apr-13 SL Week 18 29-Apr-13 UL Week 22 27-May-13 SL from my master file in the second sheet when i type in the employment no, 26 month rolling period means, i just need to extract...

That one on the second sheet is just an example so when we type in the employment it extract all the rows with SL and UL only from the master file.

26 week rolling period attendance record Week 6 4-Feb-13 SL Week 6 5-Feb-13 SL Week 16 13-Apr-13 SL Week 16 12-Apr-13 SL Week 18 29-Apr-13 UL Week 22 27-May-13 SL I need to extract all of these from the master file when i type only the employment no. So its easy for to figure out the...

28-may-2012 "-" 26-july-2013 gives a wrong answer why?

https://www.dropbox.com/s/mv254n9631hlyr8/Attendance%20sheet.xls The result i want is when i type the employment no, it extract all the Sl, Ul including its date and week. I.E the whole row with SL and UL. Any help will be much appreciated.

Serial # 265 266 1 1 1 1 1 1 Designation DC Assist DC Assist DC Assist DC Assist DC Assist DC Assist DC Assist DC Assist Division Warehouse Warehouse Warehouse Warehouse Warehouse Warehouse Warehouse Warehouse Empl # 80459 80740 80717 80911 80875 80847 80931 81098 Week Date Day Status...

Serial # 265 266 1 1 1 1 1 1 Designation DC Assist DC Assist DC Assist DC Assist DC Assist DC Assist DC Assist DC Assist Division Warehouse Warehouse Warehouse Warehouse Warehouse Warehouse Warehouse Warehouse Empl # 80459 80740 80717 80911 80875 80847 80931 81098 Week Date Day Status...