Project Specialist
Admin Manager
+1 Other

Thread Started by #dv8

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

17th October 2011 From Kuwait, Kuwait
I have given formula and completed the report with additional fields Total hours and Hours worked. Check this report
18th October 2011 From India, Eluru

Attached Files
Membership is required for download. Create An Account First
File Type: xls In-Out Log.xls (17.0 KB, 1902 views)

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….
19th October 2011 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
19th October 2011 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
20th October 2011 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.
16th December 2011 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
SQA, BOSCOITS, Yellagiri Hills, TN, S.India
19th December 2011 From India, Eluru

Attached Files
Membership is required for download. Create An Account First
File Type: xls Attendance %.xls (34.5 KB, 1148 views)

Hi all,
Does anybody out here working for a fresh vegetable and fruits company’s sales department? If so, could you please send me a sample or selling products and services presentation!
I would be very grateful, even if you could point out the headings.
Thank you in advance.
23rd March 2012 From Kuwait, Kuwait
Hi to all,
Can you please help me solving my problem?
I need to get Total Number of Lates (meaning calculation of lates in minutes/hour.
Required Time = 09:00 (in morning) 14:00 (in afternoon) *in case they come in halfday
Grace Period = 00:15
I solve already the formula on getting the tardiness
"A" = Required Time 1) (09:00)-AM and 2)14:00 PM
"B" = Actual Time 1) (09:16)-AM and 2) 14:15 PM
1) B-A = 00:16
2) B-A = 00:15
My problem is how will I combine this both formula in one cell that will compute all lates that excess 00:15 and will show on the other cell if its late or on time...
Thanks alot!
16th April 2012 From Philippines, Makati
I have an attendance register,
Where in i Mark Weekly offs as W and Leave as L.
Using countif formula i calculate number of Leave taken during a month.
I am having one problem If one employee takes leave on Saturday and Monday my Excel shows like this L,W,L , then my leave should be 3 and weekly off should be 3( if there are 4 weekly offs in a month)
i need an If condition formula , can you help
23rd January 2017 From India, Thane
Hiii to all,
help me on this,
i want a formula in attendance sheet where i get halfday calculation in today present days.
for ex-4 woff , 25 present.0 absent and 1 halfday so in my excel showing - total days present -30
but i need to get total days present -29.5
15th May 2018 From India
Dear all
i need a help i want to create a attendance sheet where i want to put in time as 8:35 or anything els but output show in Alphabets like
8:30 = P
8:40 = LC
23rd October 2018 From India, New Delhi
Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2017 Cite.Co™