Search results

Hi Guys anybody help me my previous post

The excel looks like thisParticulars Jul-11 Aug-11 Sep-11 Resources Week1 Week2 Week3 Week4 Week1 Week2 Week3 Week4 Week5 Week1 Week2 Week3 Week4 Offshore Resource A0 [ <1 year] 4 5 6 A1 [ 1 to 2 yrs] 2 A2 [ 2 to 4 yrs] 6 5 8 A3 [ 4 to 6 yrs] 8 A4 [ 6 to 8 yrs] A5 [ 8 to 10 yrs] A6...

Hi Chandoo, Its been a long time I have posted anything. Please I have a problem with which formula to use. The excel looks like thisParticulars Jul-11 Aug-11 Sep-11 Resources Week1 Week2 Week3 Week4 Week1 Week2 Week3 Week4 Week5 Week1 Week2 Week3 Week4 Offshore Resource A0...

thanks a lot hui I have learnt much from you and this sheet doesn't work in xls format I guess

Hi Hui, Can you post the template link for the same please

Hi Hui, I was trying this way http://rapidshare.com/files/434018109/Pradeepthota123.xls as per the sheet but getting 0

No still D3 I am not getting a value it is showing as 0 it should show me the actual duration but no I have tried but it failed

in the columns now it is working but the problem is I am not getting the data for the formula =IFERROR(OFFSET('r2'!$G$1,SUMPRODUCT((Date='r1'!E$1)*(Employee_ID='r1'!$A3),ROW(Employee_ID))-1,0),0) where I need to get 610 the actual duration but its not showing

Yeah I have used but nothing is working it is showing an error #name

Hi Hui, The earlier one didnot work for rhis sheet. http://rapidshare.com/files/433209561/Empdetails1.xls can you please look at this and let me know why is not working

Hi Hui, What can i say wow!!!!!!!:) for your solution But can u please explain me how does this work for 10000 or more records. And also please explain the formula.

Thanks hui for that it will save me lot of time every day don't know how to thanks you for this.But then I need to have a extra row in the that int he rows 2,3,4 I need info of Emp id 1111, and in 5,6,7 th emp id of 2222 I need to insert a row for each employee id that is the emp id should be...

Hey Hui, Thanks a lot That wonderful it could be very much useful to me and you saved my day. I need to insert a row completely after each employee id till the end of it and insert the log value for each date of the respective employee id. can you please help me on this with VBA CODE

can any body help me on my previous question

HI Hui, the data will be done for every month and the records are higher. For every new month i will get a new set of data. I want to transfer the Shift data and Log details for the appropriate date back to R1 for each day according to the name. if you can help me with formula and a...

Please find the links http://rapidshare.com/files/429761922/1.xls

http://www.2shared.com/fadmin/1705 http://www.2shared.com/document/E04Wg9Br/1_

Yeah I have done that in Rapid share and also 2shared

Hi Hui, Sorry for that ,will do that next time and thanks for giving me the URL I have uploaded the sheet if some one can help me its great

Hi Hui, I have a VBA code problem I have to insert a row after the name of every person( which is merged) in the sheet R1 and under the dates respectively I have to take the log data and insert under the same in the inserted column from r2 can you please help me on this VBA code. Can you...

Yeah it works but what if the data is huge then we cannot do it manually. Can you please suggest some other formula for this.

Hi hui, Thanks it helps me a lot. I have another question regarding the same 'IF(H159="third",(F159-11/24),F159)' F159=13-10-2010 01:16:00 now i have used this for some its ok but some others it showing value error please help me on this. 'IF(H157="third",(F157-11/24),F157)'...

Hi Hui, Thanks for the reply I have got the result for time but for date its given me the result as 00:00:00.

Hi, I have a problem with if statement now I want to select in a time sheet data if the shift is third one( 22:00:00 to next day morning 07:00:00) then I need to see select such that if shift=third, then the date for that record should be the previous one and not the actual data. Can some one...

I have a problem with date function like I have got 01-10-2010 10:45:00 I need it in dd/mm/year format and I have used the formula '=DATE(YEAR(MID(E2,7,4)),MONTH(MID(E2,4,2)),DAY(LEFT(E2,2)))' and I need time formula also can you please let me know