=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(
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(
=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
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
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
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
>>
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
