=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(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))),A3:C15,3,TRUE)
On Feb 15, 8:47 pm, ashish koul <koul.ash...@gmail.com> 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(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, Feb 15, 2011 at 4:43 PM, Nemi Gandhi <nemigan...@gmail.com> wrote: > > 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 <nsund...@gmail.com> wrote: > > > Check if mine is ok for you > > > > Thanks, > > > Sundarvelan, > > > 9600160150 > > > > On Mon, Feb 14, 2011 at 8:08 PM, ashish koul <koul.ash...@gmail.com> > > wrote: > > > > see if it helps > > > > > On Mon, Feb 14, 2011 at 5:15 PM, Nemi Gandhi <nemigan...@gmail.com> > > wrote: > > > > >> 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.com/exceldailytip > > > >> 2. Join our LinkedIN group @ > >http://www.linkedin.com/groups?gid=1871310 > > > >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > >> To post to this group, send email to excel-macros@googlegroups.com > > > > >> <><><><><><><><><><><><><><><><><><><><><><> > > > >> Like our page on facebook , Just follow below link > > > >>http://www.facebook.com/discussexcel > > > > > -- > > > > *Regards* > > > > * * > > > > *Ashish Koul* > > > > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > > > > *akoul*.wordpress.com <http://akoul.wordpress.com/> > > > > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830 > > > > > P Before printing, think about the environment. > > > > > -- > > > ---------------------------------------------------------------------------------- > > > > Some important links for excel users: > > > > 1. Follow us on TWITTER for tips tricks and links : > > > >http://twitter.com/exceldailytip > > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > > Like our page on facebook , Just follow below link > > > >http://www.facebook.com/discussexcel > > > > -- > > > Thanks > > > N.Sundarvelan > > > 9600160150 > > > > Xl0000002.xls > > > 41KViewDownload > > > -- > > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/discussexcel > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
