Rupashree Singh
2

Hiii
I have recently joined a new organisation, where my manager has asked me to prepare an attendance format in a excel sheet for all the branches & including all the vendors in a single sheet.
Pl help me out how to prepare this sheet.
Looking forward for ur valuable replies.
Thanks
Rupashree
HR Coordinator

From India, Kolkata
bcarya
162

Dear Rupashree,
This format can be prepared by following way:
First of all, on the top of the sheet, just mentioned the "Name of Location".
Then the header will be start for the table, in that keep 7 Column. S. No., Name of Empl., Dep./Desg., In Time, Sign., Out Time, Sign. You can also keep a blank column between In Time-Sign and Out Time-Sign.
That's it.
Apart from this, I will suggest you to keep separate attendance for on-roll employees and each individual vendor.
Hope this will help you. Cheers.

From India, Delhi
Rupashree Singh
2

Dear Bcarya
Thanks for your suggestion, but how will i include the vendors details also in the same sheet, as this organization works with three to four vendors. The corporate people dont need the in time & out time. But they need the details of leave, overtime, absence in the excel format.
I would be convinient if any format could have been shared.
Thanks

From India, Kolkata
bcarya
162

Dear Rupashree,
If you will use the attendance sheet with In Time & Out Time, you can easily find out the particulars you need. By using the simple signature sheet / register, you can easily pointed out the Presence and Absence. And accordingly Leave / Absence can be determined.
But, if you also need to keep track of OT, then you will have to maintain the In Time and Out Time. It may be kept in Sheets, Register or Bio-metric Attendance System. But, this is the only way to find-out the OT Hours. Because, till you don't know when the employee came in and when (s)he went out, how you will calculate Total Working Hours..??

From India, Delhi
MAHAVIR MITTAL
28

Hello,
You suggest the installation of biometric machine in the office where all the employees and vendors biodata can be configured and it remains to be a valid document. No need to get the sheet signed by any person. This is a modern system.

From India, New Delhi
anushabhumika
1

Hello Rupashree, I need Small Favour from you i Required Attendance Format
From India, Bangalore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.