Attendance tracking format

Ver Very Nice

Its not helping. Can I know what values i have to put to make it functioning.

Dear Gurpreet,
pls add the formula, if Sunday or holiday is working then it should add that day for salary to be paid extra for that day.
thanks...

Hi all,

Thanks for showing so much interest in my work. I am really excited to see such a response.

Lockwood- Really appreciate it.

Rameshbala- Can i have your email id so that i can send it to you?

Bhavani Prasad - Mailed to you.
Sumit/shreekanth - This is a default format and you will have to make amendments as per your requirements.

Please check thes points:

1) If anyone has not taken leave, it will remain as 0 by default as it is counted as 0 leaves however if someone has taken a leave, you will mark the leave by selcting the type of leave from the drop down menu.

e.g.
Suppose a person has taken leave on 5th of the month, then you will select the drop down menu on 5th infornt of his name and select the type of leave.
This will add up to his monthly total and daily total of the team.
2) Please go through my previously given detailed comments.

3) For other points , kindly be specific what u need to know abt the format.

Bibhutosh Bhadauria - kindly go through the detailed comments i have given with the attachments and confirm which point needs to be clarified on.


subhashmalik - I hope, this file gives u solution. If it doesn't then pls confirm whts more required or how it's required.

Actions required:- Apart from entering monthly details of leaves, now u just have to put the no. of days a person has worked in holidays (any holidays/sun) and then it will add up.Formulas have been amended to reflect the holidays working as planned working days.
====
Thanks

Gurpreet Singh

Attached Files

attendance_tracker_632.xls (39.0 KB, 387 views)

Thanks a tonne for the work you have done it is really useful for all. hoping more from you in future.will keep in touch with you.This is worth more when we pass it on.
regards...

hi...

u hv used planned ,unplanned, uniform etc on this...
plz explain wat is the meaning or concept...

Regards
Divya

it was interesting


thank you

Hey gurpreet.......

This a absolutely fabulous!!!!!!

Useful doc for tracking attendance....

Thanx a million.....

Hats off to you Mr. Guru!!!!!

Regards,

Paromita Mukherjee

Amaazing, i was planned to do the same. Thanks for saving my time.

Regds,

Karthick.E.M.

Dear sir
Please help me how to use this format. it is very nice format , i would like to use in a practical way.

my email id is , you can give me advise on this id also.

Regards with thanks

Hiren