Dear Friends,I am Arul. M.SC - MIS Manager , new to this site. I would like to create Attendance Sheet New formats for your desires. including (off,Half Day,Holiday, Work,Night Shift,Present,Absent,Leave)If there is any suggestion and improvement please send me a query.Reply.Thanks & Regards,ArulChennai+9840552122aruljd2009@gmail.com
From India, New Delhi

Attached Files
File Type: xls Attendance Sheet July 2009.xls (84.5 KB, 9074 views)

Hi, Welcome to CiteHR !!!!!!!!!!!!!!!!!! Nice work done .......... only one thing you can add to this format i.e. Overtime calculation (only if it is applicable). keep posting
From India, Mumbai
Hi! Good Work You can also calculate salary if u do not have any salary software. RAJEEV BHARDWAJ
From India, Delhi
Awesome work. Is it possible to add all the months in that sheet . To get both end of the month report and till date report.
From India, Calcutta
HI ,
Nice one yar, BUT can you do one favour to me i need to add three colums in leave that is PL , SL & CL. can you please ADD this 3 colums & send it to us ........
I have tried but i am not so fluent in formula making ......
THanks ,
Jyoti

From India, Mumbai
Hi, You have done excellent work.
As Jyoti said you can add PL SL and CL and after that also calculate the leaves pending in employees account as employees often come with query asking how many leaves are pending, it's a long calculation especially in case where the leaves are given on pro rata basis

From India, Vadodara
Excellent work dear kip it up........ can you please add late coming into this so that it will also have impact on overall attendance performance....plz send me i am in desperate need of it..plz yar do it fast ip possible...
This is my persomnal mail id: hr.maheshyahoo.co.in

From India, Bangalore
Hi friends Enjoy the enclosed ppt
From India, Bangalore

Attached Files
File Type: ppt HumanBrainMiracles[1][1][1].ppt (731.0 KB, 552 views)

It is very useful. Can you do one favour to me i need to add three colums in leave that is PL , SL & CL. can you please ADD this 3 colums & send it to me........
I have tried but i am not so fluent in formula making ......
THanks ,
mathangi

From India, Madras
Dear Arul ji, Very most useful posting. If you add another colum for 'Overtime' its o.k. Department wise attendance traking it will more easy to help for HR executives. Keep itup. Regards, PBS KUMAR
From India, Kakinada

If you are knowledgeable about any other fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.


Please Login To Add Reply






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2021 Cite.Co™

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server