Attendance Format Required

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

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.

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

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..??

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.

Hello Rupashree,
I need Small Favour from you i Required Attendance Format