I Have Bio Matrix device i need to pay people according so can i have any excel sheet which will calculate as present late present full present half day loss of pay as per below mentioned calculation
Timing
before 9:30 AM Present full which is 1 day present
after 9:36 AM to 10:00:59 full which is 0.75 day present
10:01 AM to 11:00:59 full which is 0.50 day present
11:01 AM to 11:59:59 full which is 0.25 day present
After 12:00 PM full day absent
From India, Bengaluru
Timing
before 9:30 AM Present full which is 1 day present
after 9:36 AM to 10:00:59 full which is 0.75 day present
10:01 AM to 11:00:59 full which is 0.50 day present
11:01 AM to 11:59:59 full which is 0.25 day present
After 12:00 PM full day absent
From India, Bengaluru
How many of you, what is the size of your manpower? Whether your bio-matrix software linked to a server and if yes find out whether the SW can be ported to Excel sheet. Is this SW open to modifications for linking Excel. If these are possible, yes you may find it possible. If your manpower is small, say about in hundreds you can use Excel independently as well. Otherwise, you have to find out a SW in the market which is compatible to both bio-matrix applications/attendance recording system and Excel like worksheet. There are sufficient no.of providers of such ready made SWs which will have provision for modifications to suit your requirement.
There are a few links on the right of your screen, pl.browse and find out info.
From India, Bangalore
1076There are a few links on the right of your screen, pl.browse and find out info.
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.
Attendance sheet.xls
TRAINING ATTENDANCE CARD.doc
Folklore Time and Attendance.pdf