Automated Time Sheet With Over Time in Microsoft Excel | Timesheet in Excel | Overtime in Excel

🔥 Automated Time Sheet With Over Time in Microsoft Excel | Timesheet in Excel | Overtime in Excel
Dosto Microsoft Excel me monthly timesheet with attendance and overtime kaise maintain kar saktey hain ? agar aap ye seekhna cahate hain to ye video apke liye bahut kaam ka hai.
is 2021 excel tutorial me main step by step btaya hai ki excel me monthly timesheet kaise bnaye, Overtime kaise nikale, over time income and regular income kaise calculate kare, workers ke liye alag alag off day kaise set kare. matlab ye bahut hi simple aur automatic time sheet hai jo apke liye bahut useful ho sakti hai. aasha hai ye video apko bahut pasand aayega.
In this video you will learn How To Create an Automated Time Sheet With Over Time in Microsoft Excel in Hindi
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
Download Training File bit.ly/3tpowhk
MS Word Complete Course : • Microsoft Word A to Z ...
MS PowerPoint Complete Course : • MS Power Point Tutoria...
Google Forms Complete Tutorial : • Google Forms Complete ...
00:00 Intro
01:26 Creating TimeSheet
10:51 Highlight OFF Day
12:48 Restrict OFF Day
14:32 Overtime and Other Calculations
#Timesheetinexcel
#OverTimeinExcel
#DeepakEduWorld
#Excel_online_course
#Microsoft_Excel
#How_To
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 ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakeduworld
Facebook Group ► / deepakeduworld

[@ashokbihari7433]

सर आप हमारे गुरु है आज आपकी मदद से हम बहुत अच्छा वर्क करते हैं आपकी कोटी कोटी नमन करता हूं

[@pa2happiness13]

Sahi bolai hai

[@ashokbihari7433]

@@pa2happiness13 thanks 👍👍👍

[@RanjeetSingh-ku9uc]

Helo sir please help me

[@omprakashthakur4515]

sir Mai jitni thank you so much Kahu utni Kam hai aapse mai bahut se bahut Naya tips or tricks learn Kiya or life Ka up Kiya only aap Ka help se mai aaj learning life me happy Hu only Aapka help se Tq sir🙏🙏🙏🙏🙏🙏

[@yes4me145]

आपकी व्याख्या बहुत स्पष्ट है। मुझे आपके सभी पाठों से लाभ हुआ। मैं आपको सलाम करता हूँ

[@kishankumar2488]

आपके videos देख देखकर मैंने इतना कुछ सीख लिया है की आपके डेमो देखने के बाद पूरा वीडियो देखे बिना same sheet बना लेता हूं। 🙏🙏 Thanks a lot Sir ji...

[@bittu25]

Thanks

[@anwarullah3790]

Kia Admi ho yaar❤️
Ap jaisy logon ki waja se i love india
Love from Pakistan❤️❤️
Hamisha khush and Abad rahoo

[@koushikmandal8311]

Bahat acha dada❤❤

[@sangeetabhatnagar738]

Thank u for sharing sir... excellent teaching

[@SALEEM0409]

Excellent job

[@purnimakundu1239]

Plz give more

[@FunnyManuare]

Sir ap ek food related ek video banaye
Food stock manegement par ek video banaye please

[@CR-um4uc]

Thanks bro

[@MegaMindTech]

Good...explained in full detail 👌

[@ujjwalajadhav7566]

nice video

[@Pawan.online.service]

Sir plz ek aisa attendance sheet and DSR baniye jisme sab kuchh a jay jaise attendance me pending week of likh ke aa jaye ki no pending week off ya 1,2 week off pending
Aor DSR me sare calculation ho jaye aisa kuchh baniyega sir plz
Aor sir mujhe bas apki video hi samjh me aati isliye mai apka sab video dekhta hu bas yahi request he ki attendance sheet aor DSR bana dijiye.....
*And thanks for all video's sir*

[@tannyakumari6709]

Nice video

[@ytvideobank5455]

Very Nice

[@ujjwalajadhav7566]

aap Ek google docs ka video banao aur google slides ka video banaiye

[@jenjenjenny1982]

English subtitles will be noce

[@shakshiariyakomre5138]

Tq sir

[@nadimkhan.4202]

Thanks g

[@Ravindra31sd]

sir app live video banaiye aap pahile video bankar badh me aplod karte hai

[@seniorchauhan9071]

School and coaching account report please next video me 👏

[@ExcelPlatform]

VERY INFORMATIVE.. EXCELLENT KNOWLEDGE
#excelplatform

[@azizurrahmanofficial970]

Well done you are the KING OF EXCEL.

[@MegaMindTech]

Yes its a good tutorial...agree 👍

[@Satyendra2022]

𝗧𝗵𝗮𝗻𝗸❤🌹🙏 𝘆𝗼𝘂💯💞💞

[@kuldeep.3012]

😯😯😯😯😯🔥🔥🔥🔥

[@jeweljunayed6571]

Needed in time and out time :)

[@hsshiva]

Awesome

[@sajidsyed2429]

Wanna about tutorials about why $ use

[@qaisarzaman473]

Good

[@irfanshaikh9597]

great work

[@manojsen1984]

Nice sir G...🙏🙏🙏 (West Bengal)

[@seniorchauhan9071]

Sir please account information for coaching and school batadijye kisi

[@bobbysriwas9878]

सर आपसे निवेदन है कि ms Excel पर एक फुल कोर्स वीडियो बना दीजिए सर..... 🙏🙏🙏🙏🙏🙏🙏

[@PUNCHINGSVMIT]

BEST

[@SUMITKUMAR-gv9zr]

Sir number ko text se alag without space .pur ak video banow.

[@sajidsyed2429]

Learning $

[@mjaved701]

Excellent

[@sumitdhiwar7502]

sir, VBA ke bare me bhi video Banaye.

[@yogitakushwaha9053]

Sir thank you for all video .I have learnt lot from you . Can you make one shot video( like powerpoint one shot video) on Adobe Photoshop . please

[@azizurrahmanofficial970]

Sir 1 video coreldraw and Photoshop per please...... I have learnt a lot from you...... Thank you sir

[@rahilgamingzone10]

Sir, aap A aur P ke saath overtime ka sheet bana ke dijiye na please.

[@rustamray4186]

Helo sir bhut bhut dhanyabad apka ek mistac hii isme agar koi off wale din Kam karta hii 5 hrs or par to oo kese hoga

[@pa2happiness13]

💞

[@67vishalkumar90]

👌😉😎🔥🔥🔥

[@sarvodayaconventvidisha1757]

Super

[@gabisalloum6122]

Deer Deepak
Actually, I followed your demo from start to end & tried to understand it but I wish you could do that in the English language & for sure it will attract more likes.
N.B could not understand the last part of your demo

[@SUMANDAS-js2kq]

Dear sir excel ka one video please basis to advance

[@warriorlegend2923]

Hello sir

[@ankushvideoscreater51]

Sir hmari company me 2 week of sath me milte hai, means 5 working day and 2 week off.
Then can we make sheets for off days. If Yes, then plzz upload a video for same

[@user-gd9fv9yg7c]

Sir in this sheet is not counted half day time. Hence please suggest the same

[@umarfaiz2036]

Hello Sir,
Please automatically sheet jis mein hum off ke employees and jis company k work karey hain in k article automatically add ho jaiye jasa k mein ek shoe company mein work karta ho tou muj ko us sheet mein (date, article, A-pairrs, B-pairs, received Pairs, Rejection Pairs,) enter karey tou wo automatically adding ho jaiye.
Thanks to you.

[@SurajSharma-Ram]

Bhai Aapse ek query thi Aasha karta hun aap reply Karenge.
Bhai mere Kaam Mein Mujhe Kuch term nikalna hota hai e.g. 6 years 5 months with age next birthday and age next birthday at retirement. Ye term nikalne k liye Mujhe teen cheezeien input Karni hoti hain Aur wo hain, DOB, start date for particular amount and retirement date. To kya aapke pass Kuch solution hai taaki hum excel Mein Kuch steps follow karke term nikal sakein?

[@sajidiqbal6999]

Bhai 1 format mri mrzi ka bnado mrbni

[@kamallochanmaduli8575]

Sir I have some doubt please help me 🙏🙏🙏
Ye sheet me hum ek month ki data save job kere to automatically ye sheet ek new sheet add ho jaye aur sheet one pehle jesa blank ho jaye....esa ho sekta hai kya sir??? Agar han to kese please botaiye...

[@prashantbarua3228]

Yeee use aayegaa kahaa, attendance m kese use kre isse?

[@ateeqmuhammad8411]

How we calculate weekly hours of month automatically
Like "first week hours"
"2nd week hours" and so on

[@azharnyazi4073]

Sir Appsheet par bhi video banaye plz

[@chandrapal1667]

Can we mention text value like "week off", in red cell.

[@dynamic_duo157]

Sir how to get series of dates with two dates same and remaining in sequence based on dropdown dates

[@Abdullahfunny104]

Sir hotel room booking
🌀bill wise reporting
🌀date wise reporting
🌀 Taxable and non taxable reporting
Please make this video

[@zakariya7677]

Lake in ye time keeper ka sheet har rose kesa save karunga

[@dynamic_duo157]

Sir
Is there any platform to clear our doubts by sending any file to you

[@mohmmadmohsin112]

सर टाइम शीट बनाते टाइम रेड सेल no off day वाली सेल को कैसे लॉक करते है आप जरूर बताए
सर मेने कई बार ट्राई किया पर नहीं हो पाया

[@lucashin2858]

Sir, normal day and Sunday and holiday overtime salary is different. How to get it in automatically. Thanks

[@MysteryMatter]

Sir Mai confuse hu : Data entry course Karu ya Accounting please reply me

[@kiranshedge9487]

Is there any way to update weekly off in text which is shown in colour

[@tahirbasha5586]

Bro how to make time sheet last 16 days and this month 15 days

[@dipankarpani6684]

conditional formatting new rule kam nehi kar raha hai, kya karu

[@whitehouserealtor1180]

Sir, kya ye sheet mil sakti h

[@fazalchandolkar3093]

HI, Can you able to send mid formula pls

[@mahmudulhasan-hl7il]

If anbody doing over time in off day how can we divide this?

[@muhammedjasif7995]

@deepak Eduworld: How can highlight weekly 2days off

[@omprakashthakur4515]

Sir one question hai plz sir help kijiye, custom formatting se Kux numberka cell value hide Kiya per Mai only cell value no hidden Ka sum Kaise Karu please sir help kijiye

[@kishankumar2488]

Aggregate formula ka use kijiye, Sum & only visible ke sath... Ex. AGGREGATE(9,5,SUM_RANGE)

[@omprakashthakur4515]

@@kishankumar2488 rows hide Nahi bro
Cell value hide by custom se

[@NeverStopLearning56]

Please add English subtitles to all your Vedios , We are unable to understand your wordings.

[@sajidsyed2429]

Which cell not equal to which cell

[@johndas8173]

Practice file kaha hai

[@BhavikAhlawat1234]

How we calculate, if 5hours worked????

[@sajidsyed2429]

$

[@Cricket_lover-g1i]

Nyc Sir ❤️ But मेरी 1 prblm solve kar दो Sir ....
Mujhe 1 aisa formula chahiye jo ki 1 count de sake Or हर cell pe use ho sake jaise ki ye 👇👇
Product value
A 450
B 560
C 1250
D 1500
E 2200
F 3350
G 4500
H 5200
अब sir मुझे इसमें ये पता करना है की
0-1000
1000-2000
2000-3000
3000-4000
4000-5000
5000+
जैसा कि मुझे पता है इसमें 1000 से नीचे सिर्फ 2 count हैं ऐसे ही मुझे सबका count चाहिए 🙆🏻‍♂️ sir ये सिर्फ expamle था Data इससे भी बड़ा है but Counting सिर्फ इनमे से ही चाहिए plz solve this my question 🙏🙏

[@prashantbarua3228]

Dataa validation lagg nahi rhaa agar humhe sheet 2 se data uthana hai

[@DeepakEduWorld]

th-cam.com/video/-IDqfwby5MM/w-d-xo.html

[@assadullah2695]

kindly send its download link

[@king_badami_724]

Sir Macro disable ho gia ha to kya karja settings ma ?????
Sir plz help

[@king_badami_724]

??? Sir app na bataya nahi

[@truptikedia3470]

Download link plese

[@user-xm5zg1oy6h]

No practice Link download

[@ujjwalajadhav7566]

i like this add a training file please

[@sandipkhanapure455]

सरजी हमारे पास बाहर के सेंटरसे डाक्यूमेंट रोज आते है और उनको उनका डाक्यूमेंट मिला है इसका कन्फरमेशन मिल सके एैसा कोई ट्रीक बताए. आपको मै th-cam.com/video/_Jqm0jfqQNo/w-d-xo.html ये लिंक भेज रहा हूं इससे कोई मदत हो सकती है क्या? एसा एक व्हीडिओ बना दिजीए

[@mysattabazar]

th-cam.com/video/2rOfYojQzD4/w-d-xo.html
सर आपने जो एस्सेल फाइल बनाई है इसको मोबाइल में कैसे उपयोग करे मोबाइल में बटन काम नही करता है कृपया इसका भी एक वीडियो बनाओ

[@tamaldinda107]

Any contact no

[@AmanSharma-rr9sk]

Complete without sence

[@Deepakdigital2.4]

Hi

[@mysattabazar]

th-cam.com/video/2rOfYojQzD4/w-d-xo.html
सर आपने जो एस्सेल फाइल बनाई है इसको मोबाइल में कैसे उपयोग करे मोबाइल में बटन काम नही करता है कृपया इसका भी एक वीडियो बनाओ

[@mysattabazar]

th-cam.com/video/2rOfYojQzD4/w-d-xo.html
सर आपने जो एस्सेल फाइल बनाई है इसको मोबाइल में कैसे उपयोग करे मोबाइल में बटन काम नही करता है कृपया इसका भी एक वीडियो बनाओ

[@mysattabazar]

th-cam.com/video/2rOfYojQzD4/w-d-xo.html
सर आपने जो एस्सेल फाइल बनाई है इसको मोबाइल में कैसे उपयोग करे मोबाइल में बटन काम नही करता है कृपया इसका भी एक वीडियो बनाओ

[@mysattabazar]

th-cam.com/video/2rOfYojQzD4/w-d-xo.html
सर आपने जो एस्सेल फाइल बनाई है इसको मोबाइल में कैसे उपयोग करे मोबाइल में बटन काम नही करता है कृपया इसका भी एक वीडियो बनाओ ।