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
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
__
> 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
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