Re: $$Excel-Macros$$ Need some help to change data format - urgent

2014-04-29 Thread Vikas
Thanks Vabz. It was indeed very helpful and saved my time. Can i ask one more thing (i m getting a bit greedy!!!) In the sample file attached the list of employees is small and also dates. is there a formula or way where the employee code and then dates would automatically get pulled in (becaus

Re: $$Excel-Macros$$ Need some help to change data format - urgent

2014-04-29 Thread Vaibhav Joshi
Hi You can do with formula, check yellow colored area. Thx On Mon, Apr 28, 2014 at 10:40 PM, Vikas Agarwal wrote: > Hi All, > > Need some help on excel calculations: > > I have a data of employee attendance (daily in/out time). The extract from > timekeeping software does come in format for m

Re: $$Excel-Macros$$ Need some help to change data format - urgent

2014-04-29 Thread Paul Schreiner
__ > From: Vikas Agarwal >To: excel-macros@googlegroups.com >Sent: Monday, April 28, 2014 1:10 PM >Subject: $$Excel-Macros$$ Need some help to change data format - urgent > > > >Hi All, > >Need some help on excel calculations: > >I ha

$$Excel-Macros$$ Need some help to change data format - urgent

2014-04-28 Thread Vikas Agarwal
Hi All, Need some help on excel calculations: I have a data of employee attendance (daily in/out time). The extract from timekeeping software does come in format for me to analyse it further, Sample file of base data and output required is attached. Request you to pls provide me a solution so th