🔥 Fully Automated ATTENDANCE Sheet With OVERTIME in Excel | Attendance Sheet in Excel
Вставка
- Опубліковано 12 вер 2024
- Agar dosto apko office me employees ki attendance overtime ke sath maintain karne me problem hoti hai to ye video apke kaam aa sakta hai... excel me fully automated attendance sheet kaise banaye jisme employee ki attendance overtime ke sath maintain kar paye ye is video me maine step by step bataya hai or mughe umeed hai excel ki ye timesheet apke kaam aayegi or aap aasani se ye sheet excel me create kar payenge, aap excel ki ye overtime attendance sheet practice ke liye download klar saktey hain, download link neeche de rakha hai. #attendancesheet #deepakeduworld #excel
in this video you will learn, How To Create Fully Automated ATTENDANCE Sheet With OVERTIME in Excel | Attendance Sheet in Excel
Download Training File : bit.ly/41sqjl5
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP TUTORIALS ►
bit.ly/3kJyIBv
Thanks for Watching
Deepak EduWorld
References : attendance sheet in excel,attendance sheet,deepak eduworld,automated attendance sheet,automated attendance sheet in excel,attendance,how to,deepak eduworld excel,employee attendance sheet,attendance register in excel,attendance tracker in excel,attendance and salary sheet,salary sheet in excel,hindi,excel for beginners,fully automated attendance sheet in excel,overtime in excel,attendance sheet with overtime in excel
Dosto kaisa laga ye video 🙏
Sir mujhe attendance sheet regarding ek help chiye main aapko kai dafa massage kiye but koi responce nahi aata main janta hu sir aap bussy hote ho isliye plzz aapka koi paid whatsgrop aur channal hai to mujhe link de
Gracias amigo por compartir excelentes tips saludos desde León Guanajuato México 🇲🇽👌👌🤝
Hlw sir
School students je liye attandance sheet banani he class wise kese banaye
Jisse sabhi bachho ka monthly avarage nikal aaye or poore saal me uske kitne working day rahe
Jaldi video aayega ….
Sir jab hm list mei month change kre to data bhi change hona chiye jaise when I will select Jan, Jan data should visible and when I click Feb then it should be blank , and when I again select Jan there should be Jan data
I learned from you a lot. Thanks for your explained videos.
Maine Apni Ecommerce company ke liye 1 interactive dashboard design kiya, Jiski wajah se mai promote bhi hua. 😊 #DeepakEduWorld
Bhai apki video bht zabrdast hoti hain , love from Pakistan 🇵🇰
Bhai mery pas excel mei 6 month ka daily basis pe data hai os ko month by month analysis karna hai let suppose Feb mei kitna kam kiya march mei kiya kam kiya, wo kaisy karen gy is pe b video banao , agr pehly se mojod hai to uska link dey do kindly
Thank you very very much God bless you and protect you and protect you I needed a French daily sheet
Bht ache se sikhate hain Deepak ji ap
Bht sundr video
On the basis of above attendance data Upload a tracker for maintaining employee weekly target working hrs , extra hours worked in a week, also staff who are woking continuously without taking any weekly day off.
Hi Deepak, Really helped this video. But I have one question if want to mention hours in time mode then how can we calculate overtime.
Bohat hi zabardast explained
A very good attendance sheet video sir
Fantastic video sir
Good information ❤
Nice and Aaapka Logo awesome hai. ...dekhne me badhiya hai.
Sir agar week me ek din off day ho aur agle week me. Usi din over time ho to kya kre
You always rocking sir ji 🎉
deepak ji b2 cell ki jaga hum dossre cells main bhi type kar sakte hai na ?
You are guru of excel
@DeepakEduWorld Hi sir, very nice and good information ❤
Great Sir,
Excellent 👌
Thanks you so much brother.
Bahot hi Sundar bhai
Sir mara ek dout haa sir agar hamara store sa alag alag location ma stock jawaga to uski entry kasa hogi
Plz give more different office works in advance Excel ...
Nice video sir ji 👍🎉❤
Thank you sir
Employee attandance off sheet taiyar kerna
Sir khatarnak 😮
Dear Sir i have need one Automatic shift roster can you teach me.
wow great explanation
Nice❤❤❤
Sir (index+match) multiple criteria with multiple result ka video banaye plz... Multiple result like whole columns and rows or as needed....
Very interesting,sir
Pls can you tell me when I change the month the cell entry of each month doesn't change it remain the same like say i enter 8 hours for Jan first day when I change the month the cell value shows 8 only when the month is changed it should be blank or the value for feb
Deepak sir bring one video on teachers+class time table in excel
খুব সুন্দর
Bhai ma chata hun ma uper sa month chang krn to os month k data har bndy ka samny ajay wo serf date chang kraa ha data nai kraa
Very informative ❤
thanks
Sir how to get only todays abseentees names in separate column...pls tell me sir...
Great ❤
Hi can you please explain how to attach a table in body to send automatic email. I watched your video for automatic email but couldn’t find how to add a table without vba. If you can explain this it would be very helpful
First viewer after you 😂😂😂😂
Suraj Jha
Super
very nice
attendance make need sheet with time in and timeout and overtime and Late then you how make Present and absence. then you make how total hours, late overtime, present, absent, total working day and monthly Salary.
I would be grateful if you make a video on how to use ChatGPT with Excel...
Sir power BI kaise seekhe ???? usko video banao please
Hi Deepak ji
It would be of great help if you could creae a video on HR analytics, i mean a dashboard if an oranganisation is having 1500 employees with 9 COmpanies under their parent company with different locations as branches, it would be a great help for us. Hope you will conisder my request which will help a lot of HR people.
Thanks in Advance
Looking for advanced excel, pivot table uses macros, dynamic dash board course details
Nice sir
Keep watching
एक ऐसा Drop down लिस्ट बनाना चाहते है जो की हम एक वर्क बुक में काम कर रहे हो। और नाम लिस्ट दूसरा वर्क बुक में हो।
क्या ऐसा बन सकता है क्या।
Hello Sir aapse ek request hai
Money income sheet per hour, per day, or monthly and expenditure detail sigh formula in excel pls 🙏 batayyena. 🙏🙏🙏🙏👍👌
Sir ishi sheet ma absent ka pross batoo plz jaldi
Sir Exal Ka Full Course Video Dijiya please.....................
Sir excel me insert tab data tab ka video banao
Project wise attendance with salary calculation kaise bnayi jaye
I using same formula but there is showing ####### not proper date 😢
This one is good but it would be better if there was time taken instead of total Hours and make a salary slip along with hours
Please tell me how to highlight other casual holiday except Sunday for all other employees together
@deepak Bhai please provide formula for overtime where the date starts with 16th Feb 2024 and ends on 15th March 2024 and this continues every month thanks for your assistance
Sir thanks for vedio ,mere office me Sundays off nhi hai [ as it is a Showroom] ..so each staff [sales executive team ]has to take week off on different days ..koi Monday lesakta hai ,aur koi Wednesday ya Friday ese ..toh ese situations me attendance sheet kese banana hai ..week offs kese highlight karna hai ..jisse salary sheet bina confusion ya mistakes se bane
Is video me bataya to hai divya g… kaise week off highlight and lock karne hain …. Bas hrs ki jaghe aap A,P use kar saktey ho absence presence ke liye…
Recently attendance sheet ka 1 video or publish kiya hai aap wo dekho or usme ye week off vala logic use kar lo
Thank you Sir
Agar weekoffs rotatinal hai toh better hoga ki aap Data Validation se Cells ko restrict na karen. Bas conditional formatting se OD ( Off Day) ko highlight kar den aur Countif se OD ko count kar len
Sir hme 2016 ka ms office chahiye pllzz link discussion me de do 🙏🙏🙏🙏🙏🙏
How to set week off sir plz give formula n make it clearly visible ...
Please share the dashboard for productivity of all employees on week base and collect monthly also
👍
your excel is amezing but mere company ko meine bola ke i am advance at excel no need to buy any software.. but they still going for it. ek din in logo ko pata chalega excel is better then software and faster then software... of course for them who knows excel better....
Deepak sir aapke paid channal ka link dijiye
Prepare MDM EXCEL SHEET
When my off day is Sunday it's not getting applied to Sunday, all other weeks are getting red, but not Sunday, why????
sir aap jab conditional formatting karke format painter use kar rahe ho mere m nhi ho pa Raha
mene sheet bhi bilkul exact banae h aapke jesi same to same same coulmn row same formula use but off day par red nhi ho Raha
please sir ya koi or Jo ye comment padh Raha h if know the solution pls reply
Sir laptop mein Microsoft MS Word kaise download Karen
Dekh k bataunga
सिर्जी आप सचमुछ जिनियस हो
Plz sir highlight all the formulas starting from Over time to last pl z I am unable to see it clearly plZ sir
Need stock market or investment sheet
Sir isme maximum present, absent or overtime dekhna h
Isme kuch Aisa ho sakta ki jaise agar hum Jan me koi entry kar rahe hai to Feb me blank ho Jaye new entry ke liye kyuki agar Jan me entry Karo kuch wahi same Feb aur baki ke month me show hoti hai
Macros use karo aap. New sheet automatically save ho jayega just ek click se
Fully automatic business management by excell and WhatsApp or Google sheet
Batao brother
What do you need ?
Res bro you've shet1,2,3 when in shet3 selecting list off going data validation you opened shet2 not able to open shet2 WHY
Are ye not equal ka sign kaise laga koi bata sakta hi kya
less than and grater than
Aree sir koi double duty karta hai usse kaise manage kare
Plz send excel sheet
Date value formula not working my laptop 2019 excel
Sir windows 7 me overtime hour nahi bata raha hai kyo sir
Ishka Excel send kro na
Bhai mera if bala formulas kam nhi kr rha h
Why file is not downloadable
i always like ur vdoa but i disliked it, banner kuch or h vdo kuch incomplete h.
Full video kyun nahi banate ho sirr
Ram ram ji mujhe ek aaisi sheet chahiye jisme ek column saler ka tatha doosra column buyer ka ho agar mai saler me buyer ki entry karu to saler ke sath sath buyer me ho jay. Please
Deepakji mujhe aapka mobile number chahiye.
सर आपने जो ये अटेंडेंस शीट बनाया है। अगर ड्यूटी का समय 8 घंटे है, और कोई भी बंदा 12 घंटा ड्यूटी करता है तो ओवरटाइम वाले कॉलम में 4 घंटा ओवरटाइम ऑटोमैटिक ऐड हो जाएगा।
अगर मान ले की आज के दिन कोई भी फेस्टिवल है, जैसे- दिवाली, ईद इत्यादि और कंपनी का बॉस बोलता है की आज आप सभी को ड्यूटी आना है उसका ओवरटाइम मिलेगा। और सबलोग ड्यूटी किया, और अटेंडेंस शीट में 8 घंटे घंटे डाल दिया गया, मगर जो 8 घंटे attendance शीट में ऐड किया गया वह ओवरटाइम में कैलकुलेट नहीं कर रहा है, क्योंकि वह तो regular वर्क डे है इसलिए, इसको क्लीकुलेट कैसे कराएंगे। कृप्या इसपर विडियोज बनाएं।
यदि आपको मेरा प्रश्न समझ नही आया होगा तो कृप्या मेरे व्हाट्सएप पर कॉन्टैक्ट कर सकते हैं।
Whatsapp no- 9852469250