We had alternate working days scheduled by company during recent rise in covid cases. Instead of 8 hours working we were asked to do 10 hrs. Now due to some emergency i had to take a leave. The HR is asking me to apply for 3 days leave including holidays as per shift schedule. Here it is not sandwich leave policy. It is sandwich working day policy. I personally feel this is mistreatment by the employer. Am I right or wrong to feel this way.
Sir , first of all, this is really a great work done by you and i respect the your intension of spreading knowledge free of coat by this video . Great. Secondly, i am trying since two days and also asked my colleagues how to use the formull for adding date which should not exceed the date mentioned in the month but we are not able to get it. Like if i want in the month of feb 29 ,30 & 31 should not come ,then also it is comming. Formula is exactly same as you have given . Kindly help me on this please . 🙏
Best pay roll labour low..... Sir agar labour low na use kar ke local payroll kase tayar kare (contraction line me jase use ho ta hai ). Ek labour half prasant hota hai or dusra labour 1/3 (sva) ya 1/4(pavna ) ye sabhi hajre kase lagaye ya eska koi alag labour attendance Idea dije ye...... Plse?????
Sir thank you very much it's helped a lot...but it's possible to add some features like advance payment, deductions like PF Esi, and other deductions like late fines and bonuses, loans,s, etc and abcouse salary calculation with edited holidays in the month because my work in contractor line there is no set of holidays so let the user decide the holidays.....then let make a new version of the video on it and it saved a lot of money...
Great video, can u also make a video linking this attendance sheet to leave balance sheet of an employee & also a "monthly in & out automatic time sheet of an employee in excel" ?
Hello! How and WHERE (which cell...) did you add the formula for automatically adding the Rest Day (R) in the Attendance Table... The cells are already a data-validated Drop-down List and how to add this formula in the same cells! Could you please reply. Thanks.
Sir is sheet me month change krne par bhi wahi attendance show ho rhi hai jo apne last month me enter kari har month me blank sheet individually open honi chahiye so that alag alag ho ske
As per RSP RULES, WE HAVE TO SHOW OVERTIME (AS P2) IN MUSTER WITH PRESENT STATUS (AS P), WHILE FORMULATING, EITHER (NO. OF P'S) OUTPUT OR (P2'S) OUTPUT IS COMING, THE CELLS SHOULD COUNT SUM OF BOTH OF THEM, HOW THIS CAN BE DOWN....
Dear Sir, This is very helpful for labour contractors. Thanks Required Daybook Excel format for maintaining daily payment receipts transaction. Please reply
Sir how to calculate A Shift G shift B shift C shift and C4 shift 4 meaning 4hours when calculate completely AGBC calculate one column and C4 1.5 duty 4 Meaning 0.5 duty...... Plz give formula sir.
plz provide practice sheet for download,,,,it is not available anywhere?......................most of the tutorials are providing this to help aspirants practicing offline after download. I think one year passed, it can be updated as many viewers demanded that sir.
Very nice 👌👌 BTW, is it still mandatory to keep daily Muster-roll n POW register in hand written form? Can computerised processing replace them, or is it to be used alongside manually maintained records (as a month-end processing tool or aid) ? TIA.
Aa not working exactly if the month have A value added the value always there if you change the months..means if your absent in August you will absent in sep,oct,nov it doesn't renew
Hi LLA, I need your help on the same kind of work. I need to highlight random but cinsecutive2 days week off for random 4 or 5 employee out of 20 every week. i have a ready sheet but i am unable to put in WeekOff in this way. can you really help?
Where is column "D" in the excel sheet. Why the if formula for number of days according to different months is not working even after putting it correctly??
Sir, Mujhe mere boss ne lockdown mai four month ki salary di (Mar-Apr-May-Jun) Lekin July Mai maine pure month kam kiya lekin August main Chhod diya, Ab Mere Boss July ki salary nhi de rahe hai bol rahe hai lockdown mai jo salary di hai free mai uske hisab se kuch dena nhi banta batao main kya karu????? Help Me
main aapse contact karna chahta hun, maine new join kiya hai as a supervisor. excel pe employee attendance and salary calculation karna hai, sikhne me thoda time lagega. mujhe abhi pichhle month ka salary sheet prepare karana tha. kya aap meri help karogo please.
Waise solution mil gaya, thoda khatne k baad, sir ji ne toh khali upar upar dikha diya, asli jagah chod diya taki kar na sake. But kya kare, kosish bari buri bala hai.
bhai saahub aajkal bahut saari companies main ek faltu sa rule chalaya jaaraha hai jaise k koi employee satarday yaa Monday ko apsent hotha hai..tho uski sunday ki presentiee bhi kaati jaati hai jo bilkul ghalat hai...please ise rukwaiye...
किसी ऑफिस मैं 24 हॉयर वर्क होता है साथ ही सबको 7 दिन मैं एक बार रेस्ट देना होता है एल। लेकिन रेस्ट संडे से नही बल्कि 7 दिन मैं एक बार तो देते है लेकिन लूपिंग प्रोसेस से उसकी जगह दूसरा वर्क करता है फिर उसे भी 7 दिन मैं एक बार रेस्ट देना होता है उस अटेंडेंस को बनाना सिखाए।
I have to maintain attendance of my online classes, but the problem is the classes are only on Mondays and Thursday. I don't want to show all other days of week. CAN YOU PLEASE HELP 🙏
Sir can you help to create School time table for teachers? say in a School there are 30 teachers, and each class has 2 division as 10a and 10b 9a 9b. And so on. One teacher may teach 10a one subject and not teach 10b but teaches 9a and 9b.. can this automatically be done? By entering one column ,teachers subjects and classes so that it automatically adjusts and not coincide two classes at same time?
Sir Mere father West Bengal ke transport department Mein driver ke post per karykrat the Unka nidhan 2 sal pahle ho chuka hai Sar Mein service ke liye eligible Ho Main anukanpa through kis parker nakuru prapt kar sakta hun....please tell me sir
Sir formula jaisa apka m kaam kr rha hai waise Mera m nhi kr rha Jaise Date m 28 tk aana Chahiye but Mera m 31 days tk ja rha r weekday bhi Sahi nhi aa rha
if i mark A in a month then if i change to another month A is reflecting to the month, and i change that it is reflecting to the previous monthis gone, can anyoone help me.
COURSES: labourlawadvisor.in/link/LPTI
DEMAT ACCOUNT: link.labourlawadvisor.in/demat
QuickPayroll: quickpayroll.in/
I want more knowledge about payroll and labour laws
We had alternate working days scheduled by company during recent rise in covid cases. Instead of 8 hours working we were asked to do 10 hrs. Now due to some emergency i had to take a leave. The HR is asking me to apply for 3 days leave including holidays as per shift schedule. Here it is not sandwich leave policy. It is sandwich working day policy. I personally feel this is mistreatment by the employer. Am I right or wrong to feel this way.
he
he
Sir , first of all, this is really a great work done by you and i respect the your intension of spreading knowledge free of coat by this video . Great.
Secondly, i am trying since two days and also asked my colleagues how to use the formull for adding date which should not exceed the date mentioned in the month but we are not able to get it. Like if i want in the month of feb 29 ,30 & 31 should not come ,then also it is comming. Formula is exactly same as you have given . Kindly help me on this please . 🙏
I have solution
Best pay roll labour low.....
Sir agar labour low na use kar ke local payroll kase tayar kare (contraction line me jase use ho ta hai ).
Ek labour half prasant hota hai or dusra labour 1/3 (sva) ya 1/4(pavna ) ye sabhi hajre kase lagaye ya eska koi alag labour attendance Idea dije ye......
Plse?????
Awesome and I respect you.Thanks universe Sir.I am from Myanmar.
Sir thank you very much it's helped a lot...but it's possible to add some features like advance payment, deductions like PF Esi, and other deductions like late fines and bonuses, loans,s, etc and abcouse salary calculation with edited holidays in the month because my work in contractor line there is no set of holidays so let the user decide the holidays.....then let make a new version of the video on it and it saved a lot of money...
Best use of excel. Further you explained in best way sir.🥇🥇🥇😊
Great video, can u also make a video linking this attendance sheet to leave balance sheet of an employee & also a "monthly in & out automatic time sheet of an employee in excel" ?
It is very useful information video sir. Thanks for your valuable support and update.
I like your videos sir, thank you very much sir.
Awsome sir thank's for sharing such a beneficial information keep it up👍😊
Very good sir gee
Excellent
Very knowledgeable 👍
Hello! How and WHERE (which cell...) did you add the formula for automatically adding the Rest Day (R) in the Attendance Table... The cells are already a data-validated Drop-down List and how to add this formula in the same cells! Could you please reply. Thanks.
SAME
Huge respect.. amazing work done 👍
Sir is sheet me month change krne par bhi wahi attendance show ho rhi hai jo apne last month me enter kari har month me blank sheet individually open honi chahiye so that alag alag ho ske
Very nice sir 😊
DEAR SIR, how to calculate days as you mention above the last date in a video by formula if attendance calculated from 26th to 25th of every month?
As per RSP RULES, WE HAVE TO SHOW OVERTIME (AS P2) IN MUSTER WITH PRESENT STATUS (AS P), WHILE FORMULATING, EITHER (NO. OF P'S) OUTPUT OR (P2'S) OUTPUT IS COMING, THE CELLS SHOULD COUNT SUM OF BOTH OF THEM, HOW THIS CAN BE DOWN....
Thanks for that video
Best trick bhai
Half day hoga to woh to pura ek din count karega na...???
Dear Sir,
This is very helpful for labour contractors. Thanks
Required Daybook Excel format for maintaining daily payment receipts transaction. Please reply
day book as in payment receipts ?
Yes Sirjiii
What is the Rule for base days or payable days in month 30 or 31? Some companies considering 30 for everymonth. How it works? Plz help me
Attendance nice registers
Thankyou very much for sharing your knowledge.
huge resoect sir🙂
Helpful video
Hi I am unable to increment the date using the If formula you have mentioned, please help me on that
Dear sir ji so nice
Aapka institute kaha pr h sir ji. Jaipur me
For traning ke liye
Please make a video on recent changes in ESI Employee registration w.e.f. 01.07.2020
Mobile no and bank details compulsory kiya hai
11:50 par jo formula hai ye to sabhi month me phir se lagana hoga
Amazing sir
CAN YOU PLEASE CLARIFY THE FORMULA OF IF, YOU APPLY ON THE DATE COLUMN =IF(G4
Dear Rishabh bhai You have told that date should be come as per month by bulid up formula but whenever i build this formula it dose not done
Thanks a lot
What about substitute off? What if I want to give first weekly off on Monday, and second weekly off on the next sunday?
Nice
Sir how to calculate A Shift G shift B shift C shift and C4 shift 4 meaning 4hours when calculate completely AGBC calculate one column and C4 1.5 duty 4 Meaning 0.5 duty...... Plz give formula sir.
Namaskar Sar ji
Plz also explain sir how to calculate all present absent w/o GH in one cell
plz provide practice sheet for download,,,,it is not available anywhere?......................most of the tutorials are providing this to help aspirants practicing offline after download. I think one year passed, it can be updated as many viewers demanded that sir.
Thanks sir,
Pls teach hourly base calculation with lunch break
KINDLY EXPLAIN OVERTIME SHEET TOO
How can make attendance sheet with Over time and double shifts adjustment in Excel sheet
Very nice 👌👌
BTW, is it still mandatory to keep daily Muster-roll n POW register in hand written form? Can computerised processing replace them, or is it to be used alongside manually maintained records (as a month-end processing tool or aid) ? TIA.
Better to take print every month and keep it signed
@@LabourLawAdvisor Okay Sir.
Sir please if we work on rest day, will it count overtime
Sir, provide this excel sheet to us.
zeezoellp@gmail.com
Saare Month m same data aa rha hai
ager april m Present lagai to sare month m present aa rha hai
Aa not working exactly if the month have A value added the value always there if you change the months..means if your absent in August you will absent in sep,oct,nov it doesn't renew
=if(G4
Interested to learn payroll calculations on excel sheet, but how either online, offline, ppt etc. Course time with payment details.
Hi LLA, I need your help on the same kind of work.
I need to highlight random but cinsecutive2 days week off for random 4 or 5 employee out of 20 every week. i have a ready sheet but i am unable to put in WeekOff in this way. can you really help?
What is $AM$ in date and day formula ......It's not working in my excel sheet . Plz clear
same query
How to prepare automatic attendance sheet for june 26 to July 25 dates . Which type formula we have use in this type of days can u suggest me.
That's complex to.prepare in Excel
Sir,ak duty dana ka kitna hrs bade dusra duty lagna chaiya
Sir please upload ,Automated Rotational off day calculation of particular department ka kaise banaye jayega
Isme rotational day kar sakte ho simply change the week.off day 1 2 3 etc
But after 14:04 min in the vedio if you change the month the same data of present and absent appears for every month of the previously selected month.
Thanku sir
If rest day is saturday and sunday? what we do now?
Good Evening Boss 🌻
Last count if formula you give that when I didn't understand can you send me the confirm.Thanks sir this Aman
Where is column "D" in the excel sheet. Why the if formula for number of days according to different months is not working even after putting it correctly??
Sir kya over time 9 hrs ke baad count hota hai.aisa law hai
Sir, Retail के लिए भी कोई नियम है कया! यहां पूरा काम करने के बाद भी पैसे नही दिए जा रहे हैं!
=IF(G4
Same here did u find the solution bro??
@@aryamanmadan2569 Equate the G4 cell (in video) to first date cell... Excel automatically detects 1 as a number so you are getting the error
1 date G4 cell reference =AD3
Sir, Mujhe mere boss ne lockdown mai four month ki salary di (Mar-Apr-May-Jun) Lekin July Mai maine pure month kam kiya lekin August main Chhod diya, Ab Mere Boss July ki salary nhi de rahe hai bol rahe hai lockdown mai jo salary di hai free mai uske hisab se kuch dena nhi banta batao main kya karu????? Help Me
Sir rti ke dwati apil ka jawab kitne din me dena hota hai
main aapse contact karna chahta hun, maine new join kiya hai as a supervisor. excel pe employee attendance and salary calculation karna hai, sikhne me thoda time lagega. mujhe abhi pichhle month ka salary sheet prepare karana tha. kya aap meri help karogo please.
=IF(E4
Sir This formula not work in sheet please explain us. =IF(G4
Bhai work karega paisa deke class lelo. Bina paisa ka muft ka gyan kaun deta hai. Purana jamana mei bhi toh exchange wala policy tha, kuch do kuch lo.
Waise solution mil gaya, thoda khatne k baad, sir ji ne toh khali upar upar dikha diya, asli jagah chod diya taki kar na sake. But kya kare, kosish bari buri bala hai.
sir how we give 2 days off in this sheet Sat nd Sunday .... plz guide
bhai saahub aajkal bahut saari companies main ek faltu sa rule chalaya jaaraha hai jaise k koi employee satarday yaa Monday ko apsent hotha hai..tho uski sunday ki presentiee bhi kaati jaati hai jo bilkul ghalat hai...please ise rukwaiye...
किसी ऑफिस मैं 24 हॉयर वर्क होता है साथ ही सबको 7 दिन मैं एक बार रेस्ट देना होता है एल। लेकिन रेस्ट संडे से नही बल्कि 7 दिन मैं एक बार तो देते है लेकिन लूपिंग प्रोसेस से उसकी जगह दूसरा वर्क करता है फिर उसे भी 7 दिन मैं एक बार रेस्ट देना होता है उस अटेंडेंस को बनाना सिखाए।
I have to maintain attendance of my online classes, but the problem is the classes are only on Mondays and Thursday. I don't want to show all other days of week. CAN YOU PLEASE HELP 🙏
But we have to in time out time also in the same sheet
What is the formula for LC(late coming)
Hi Sir
Can you suggest any attendance app free to use version
Hi I wanted to know details about the esic. Please reply
hi sir my formula is not working =if(e4
I have solution
This problem
Hello gentle man I created same as of your excel sheet but the formula it’s incorrect & one mor thing in your excel I don’t see cell no D ?
industrial dispute act applicable in collage non teaching staff
yes but if emp is on roll of contract job or totally depending of his/her nature of service
What changes u have made in excel because i have problem of circular formula.. especially with the formula of date
same here
SIR MONTH CHANGE KRNE PR BHI SAME LAST MONTH WALI SHEET WALA DATA OPEN HOW HU RHA HAI KYA KAROON?
Sir iam intrested in the payroll course but i would like to know the installments options and the duration of the course
The course is available on EMI option check that out or contact team via WhatsApp number
THE FORMULA YOU SHOWED IN THE DATE SERIES IS NOT WORKING FOR ME OR I THINK I AM UNABLE TO DO SO, WOULD YOU PLEASE HELP ME?
This excel book is not correct. when you select the month, the below attendance data is the same for all months.
Same with me
What if my date Will not change by changing each month?
Sir iss list ko शुरू se बनाए pless
Thanku Sir
Dear Sir
FSSAI or MSME Udhyog Registration k process bataye sir ....Video bana kar...plz
Can you share the Excel Sheet
Sir, pls tell me how to calculate average attendance percentage of a class
Sir I want to know that how can join ur course.
Sir can you help to create School time table for teachers?
say in a School there are 30 teachers, and each class has 2 division as 10a and 10b 9a 9b. And so on. One teacher may teach 10a one subject and not teach 10b but teaches 9a and 9b.. can this automatically be done? By entering one column ,teachers subjects and classes so that it automatically adjusts and not coincide two classes at same time?
Sir Mere father West Bengal ke transport department Mein driver ke post per karykrat the Unka nidhan 2 sal pahle ho chuka hai Sar Mein service ke liye eligible Ho Main anukanpa through kis parker nakuru prapt kar sakta hun....please tell me sir
They working in Govt Department?
Please share this excel link to download
Sir R and P automatically set that formula is not work pls advise 🙏
Sir formula jaisa apka m kaam kr rha hai waise Mera m nhi kr rha Jaise Date m 28 tk aana Chahiye but Mera m 31 days tk ja rha r weekday bhi Sahi nhi aa rha
sir mujhe attance sheet se date of joining find jarni hai mea8n jis pahle date se wo present ho to wo date uska date of joining ho jaye .
What for overtime
sir day formula not work =TEXT(G4,"dddd")
if i mark A in a month then if i change to another month A is reflecting to the month, and i change that it is reflecting to the previous monthis gone, can anyoone help me.