Re: $$Excel-Macros$$ week based time-sheet Using master tracker

2015-05-05 Thread sandeep payal
Dear Sir, PFA for Master Tracker. On Tue, May 5, 2015 at 2:26 PM, Prasanna Jayashankar wrote: > Hi Sandeep, > > The sheet you have posted looks like the output required . Could youi also > share the "master attendance tracker" mentioned above. > > Does it contain the collumns: > Date,Name, Em

Re: $$Excel-Macros$$ week based time-sheet Using master tracker

2015-05-05 Thread Prasanna Jayashankar
Hi Sandeep, The sheet you have posted looks like the output required . Could youi also share the "master attendance tracker" mentioned above. Does it contain the collumns: Date,Name, Emp Code, Travel Distance etc Do you want a macro based solution or a formula driven solution ? On Sunday, May

Re: $$Excel-Macros$$ week based time-sheet Using master tracker

2015-05-02 Thread Ashish Kumar
Hi Sandeep, Elaborate more. What kind of output you want...! Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accu

$$Excel-Macros$$ week based time-sheet Using master tracker

2015-05-02 Thread sandeep payal
hello guys i have to create week based time-sheet from master attendance tracker Pls help.PFA for Week 1 Sample. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel