PoojaVS
hi Deepu,
I know this is probably an old post, but Im at a new job and I need some help as a part of my duties I have to handle HR and keep records of Leave days. Im not great with excel and im from east africa so leave days and sick leave and other leave is not the same as india.
Is there anyway you can help me?

From Kenya, Nairobi
sm dmu
Dear Mr. Deepu..

Hi...this is John here. Kindly provide me a .xls format of leave record data with the following topics...

20 employees..

following leave

CL -------------- 7

SL -------------- 7

PL -------------- 2 pl added automatically every month from end of 3rd month onward and at the end i.e, 12th month

3 pl will add. total 21 PL.

C/Off ----------- when work in w/off and holidays (1 comp off will add automatically)

Absent --------- as and when required

Present -------- as applicable

Any other Leave.--- as applicable

Moreover holidays as per requirement can be adjusted which will reflect indicating the column colour.

the sheet should be like, i am maintaining the record monthly and a separate sheet for each employee

will create automatically where I can display the summary of each employee at the end of year.

Thanks & Regards,,John

From India, New Delhi
Kanha111
Dear Deepu, How to show absent in monthly leave sheet. Thanks & regards. Kan Singh Rathore
From India, Ahmedabad
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.