Dears,
Being stucked on making an attendance formula as below.
As our day starts from 8.00 to 17.00, how do we use formula “IF” to calculate the late come & went early time precisely.
Can anybody help me out please..
Emp Name Time In Late Come Time Out Went Early Total Hours
Gavin Mulligan 7:43:00 0:17:00 16:45:00 0:15:00 9:02
From Kuwait, Kuwait
2Being stucked on making an attendance formula as below.
As our day starts from 8.00 to 17.00, how do we use formula “IF” to calculate the late come & went early time precisely.
Can anybody help me out please..
Emp Name Time In Late Come Time Out Went Early Total Hours
Gavin Mulligan 7:43:00 0:17:00 16:45:00 0:15:00 9:02
From Kuwait, Kuwait
I have given formula and completed the report with additional fields Total hours and Hours worked. Check this report
From India, Eluru
From India, Eluru
Thanks a ton buddy will check and amend it accordingly and the provided provision was indeed helpful as our office hasn’t proper time for lunch time.
Once again thank you and Have a great day….
Dv8dawn
From Kuwait, Kuwait
Once again thank you and Have a great day….
Dv8dawn
From Kuwait, Kuwait
than ku for sharing this, Can you help me people come various shifts, ForExample Shift "A" 6:00Am to 2:00pm Shift "B" 2:00 pm to 10:00pm Shift "C" 10:00pm to 6:00am. Regards Satish
From India, Hyderabad
From India, Hyderabad
To Sathish I have given the place to specify Start time(D1) and End time(G1). There give the data and get the result. SQA, BOSCO-ITS, Yellagiri Hills
From India, Eluru
From India, Eluru
Dear Members ,
Please provide me the formula for setting the attendance target . (Ex: If i have to set Attn. % should be 90 for one month for all emplyoees). this i require for updating the MIS only.
Regards,
From Singapore, Singapore
Please provide me the formula for setting the attendance target . (Ex: If i have to set Attn. % should be 90 for one month for all emplyoees). this i require for updating the MIS only.
Regards,
From Singapore, Singapore
To Anjali
You can set the Attendance % in your policy and followup can be done thru the excel in attachment.
Sort the report by % to view the report in order
Regards
SQA, BOSCOITS, Yellagiri Hills, TN, S.India
From India, Eluru
You can set the Attendance % in your policy and followup can be done thru the excel in attachment.
Sort the report by % to view the report in order
Regards
SQA, BOSCOITS, Yellagiri Hills, TN, S.India
From India, Eluru