🔥 Fully Automated ATTENDANCE Sheet With OVERTIME in Excel | Attendance Sheet in Excel
ฝัง
- เผยแพร่เมื่อ 10 พ.ค. 2023
- 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
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
Bohat hi zabardast explained
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
Fantastic video sir
Good information ❤
Thanks you so much brother.
Great Sir,
Excellent 👌
You always rocking sir ji 🎉
Nice and Aaapka Logo awesome hai. ...dekhne me badhiya hai.
thanks
Bahot hi Sundar bhai
A very good attendance sheet video sir
Very informative ❤
You are guru of excel
wow great explanation
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
@DeepakEduWorld Hi sir, very nice and good information ❤
Thank you sir
Great ❤
Nice video sir ji 👍🎉❤
Nice sir
Keep watching
Very interesting,sir
Nice❤❤❤
very nice
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.
Sir khatarnak 😮
খুব সুন্দর
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.
Plz give more different office works in advance Excel ...
Super
I would be grateful if you make a video on how to use ChatGPT with Excel...
First viewer after you 😂😂😂😂
Suraj Jha
Looking for advanced excel, pivot table uses macros, dynamic dash board course details
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
deepak ji b2 cell ki jaga hum dossre cells main bhi type kar sakte hai na ?
Deepak sir bring one video on teachers+class time table in excel
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
👍
Sir agar week me ek din off day ho aur agle week me. Usi din over time ho to kya kre
Sir (index+match) multiple criteria with multiple result ka video banaye plz... Multiple result like whole columns and rows or as needed....
Dear Sir i have need one Automatic shift roster can you teach me.
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
Please tell me how to highlight other casual holiday except Sunday for all other employees together
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 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....
Sir power BI kaise seekhe ???? usko video banao please
Sir how to get only todays abseentees names in separate column...pls tell me sir...
Dekh k bataunga
Sir excel me insert tab data tab ka video banao
Sir Exal Ka Full Course Video Dijiya please.....................
Employee attandance off sheet taiyar kerna
Sir ishi sheet ma absent ka pross batoo plz jaldi
Project wise attendance with salary calculation kaise bnayi jaye
Hello Sir aapse ek request hai
Money income sheet per hour, per day, or monthly and expenditure detail sigh formula in excel pls 🙏 batayyena. 🙏🙏🙏🙏👍👌
Need stock market or investment sheet
How to set week off sir plz give formula n make it clearly visible ...
Deepak sir aapke paid channal ka link dijiye
सिर्जी आप सचमुछ जिनियस हो
एक ऐसा Drop down लिस्ट बनाना चाहते है जो की हम एक वर्क बुक में काम कर रहे हो। और नाम लिस्ट दूसरा वर्क बुक में हो।
क्या ऐसा बन सकता है क्या।
When my off day is Sunday it's not getting applied to Sunday, all other weeks are getting red, but not Sunday, why????
@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
Prepare MDM EXCEL SHEET
Fully automatic business management by excell and WhatsApp or Google sheet
Batao brother
What do you need ?
Sir hme 2016 ka ms office chahiye pllzz link discussion me de do 🙏🙏🙏🙏🙏🙏
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 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
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.
Plz send excel sheet
Plz sir highlight all the formulas starting from Over time to last pl z I am unable to see it clearly plZ sir
Sir isme maximum present, absent or overtime dekhna h
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
Date value formula not working my laptop 2019 excel
Ishka Excel send kro na
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
I using same formula but there is showing ####### not proper date 😢
Aree sir koi double duty karta hai usse kaise manage kare
Sir windows 7 me overtime hour nahi bata raha hai kyo sir
Are ye not equal ka sign kaise laga koi bata sakta hi kya
less than and grater than
Bhai mera if bala formulas kam nhi kr rha h
Full video kyun nahi banate ho sirr
i always like ur vdoa but i disliked it, banner kuch or h vdo kuch incomplete h.
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