Re: $$Excel-Macros$$ RASHI QUERRY

2011-02-16 Thread Prakash Gusain
=VLOOKUP(IF(SUM(VLOOKUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))>K8,SUM(VLOOKUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))- K8,SUM(VLOOKUP(

Re: $$Excel-Macros$$ RASHI QUERRY

2011-02-16 Thread Nemi Gandhi
Thank you very much Aashishbhai...incredible! nemi On Feb 15, 8:47 pm, ashish koul wrote: > VLOOKUP(IF(VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)>= > 1440,VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)-1440,VLOOKUP(

RE: "$$Excel-Macros$$ RASHI QUERRY"

2011-02-15 Thread Prakash Gusain
=VLOOKUP(IF(SUM(VLOOKUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))>K8,SUM(VLOOKUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))-K8,SUM(VLOOKUP(D

Re: $$Excel-Macros$$ RASHI QUERRY

2011-02-15 Thread ashish koul
VLOOKUP(IF(VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)>= 1440,VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)-1440,VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)),$A$2:$C$15,3,1) On Tue

Re: $$Excel-Macros$$ RASHI QUERRY

2011-02-15 Thread Nemi Gandhi
Thank you Mr. sundervalen, but i need only one formula instead of calculating value for date, month and time separately,. Is it possible? and thank you to Mr. Ashish kaul also for help. On Feb 14, 8:42 pm, Sundarvelan N wrote: > Check if mine is ok for you > > Thanks, > Sundarvelan, > 9600160150

Re: $$Excel-Macros$$ RASHI QUERRY

2011-02-14 Thread Sundarvelan N
Check if mine is ok for you Thanks, Sundarvelan, 9600160150 On Mon, Feb 14, 2011 at 8:08 PM, ashish koul wrote: > see if it helps > > > On Mon, Feb 14, 2011 at 5:15 PM, Nemi Gandhi wrote: > >> attached herewith rashi querry sheet. Please provide me formula and help. >> >> -- >> Nemi Gandhi >>

Re: $$Excel-Macros$$ RASHI QUERRY

2011-02-14 Thread ashish koul
see if it helps On Mon, Feb 14, 2011 at 5:15 PM, Nemi Gandhi wrote: > attached herewith rashi querry sheet. Please provide me formula and help. > > -- > Nemi Gandhi > 98204 92963 > > -- > > -- > Some important links

$$Excel-Macros$$ RASHI QUERRY

2011-02-14 Thread Nemi Gandhi
attached herewith rashi querry sheet. Please provide me formula and help. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.co