No Tags Found!

SH

Shai89308

Executive Hr

AS

Ammu Shanvi

Human Resource

GS

G SHASHI KRISHNA

Senior Manager - Hr

AH

Aizant HR

Human Resources

MA

MARSHAL

Safety Officer

AK

Anish Katoch

Hr Executive

PR

PranjalR

Hr Recruiter

AP

Alka Pal

Hr Executive

Karthikeyan8195

Management Consultant

MK

Mohit Kumar Puri

Head Marketing

AU

Austex

Accounts Manager


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, 2350 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, 1448 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
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.





About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.