No Tags Found!


dv8
2

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
asqa
7

I have given formula and completed the report with additional fields Total hours and Hours worked. Check this report
From India, Eluru
Attached Files (Download Requires Membership)
File Type: xls In-Out Log.xls (17.0 KB, 2443 views)

dv8
2

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
satish__kumar
4

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
asqa
7

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
Anjali_Kapoor
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
asqa
7

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
Attached Files (Download Requires Membership)
File Type: xls Attendance %.xls (34.5 KB, 1497 views)

dv8
2

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

From Kuwait, Kuwait
MaricelLara
2

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.
Ex.
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
Ex:
"A" = Required Time 1) (09:00)-AM and 2)14:00 PM
"B" = Actual Time 1) (09:16)-AM and 2) 14:15 PM
Actual:
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!

From Philippines, Makati
raghavendravijayrao
1

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

From India, Thane
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.