How To Calculate Overtime Hours in Excel in Hindi || Time calculation
ฝัง
- เผยแพร่เมื่อ 19 ส.ค. 2024
- this video explained how to calculate overtime hours in excel in Hindi: its easy to calculate over time[overtime] hours and regular hours in excel. here in this video we show you how to calculate overtime hours and regular work hours. IN HINDI and which excel formulas is used to calculate overtime hours and regular work hours in excel in Hindi. #overtime #deepakeduworld #excel
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 ► / deepakedu. .
Facebook Group ► / cse92
We Always Provide Useful & Helpful Content On The Deepak Eduworld TH-cam Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.
Sir apka video best muje TH-cam se ak achcha computer shikhne ki niya ak bahat achcha channel mil gaya ❤❤❤
Deepk Bhai aapne ko bhut dhanyawad
Thank u sir
Plz sir make a video overtime + salary calculation in full automatic attendance sheet video
Thanks a lot Deepak, i tried Actual Hrs worked too and instead of 1 hour break i used 30 mins by customizing the cell, and it worked out pretty well. i actually watched many videos of time formula and i just couldn't understand their technique, you explained it really well. I really appreciate your work.
Sir duwa karta hoon app hamesa hamse jure rahe our aise hi video upload karte rahe I am your big fan
+Sanu Nayak 👍👍👍👍
Sir ! Aap ki video bahut hi achhi hai samajh me perfectly sa gaya thanx sir!
Excellent video sir
Really very helpful
Deepak sir plz ek formula btaye jisme present or absent ke sath overtime bhi automatic count ho jaye
Bohut bohut Umda, Lajawab, Behtreen, Shandar. Dekhkar Maza agya 🤗🤗🤗🤗🤗🤗🤗
Kya aap excel me job krte ho
No problem. I got the trick to solve this problem. Thanks for replying.
Deepak bro you did well on your TH-cam channel.
I subscribed your channel today.
Swear to God you have excellent skill of teaching. I did office course but never understand completely in detail but you explain in each and every thing very precisely. I must say you teach in depth so a person who has not used excel can even understand.
sir aap ki video best hai but jaise aap hour calculate krte waise hi salary hum kaise calculate karen, jaise , overtime ki salary and bonus kaise calculate karen
pura month ka employee wise kyse maintain kar sakta hu ??..pls ek video baniye
Good video.. thankyou
Thank you so much sir ....For this video....
Deepak sir I am fan of you please you give me introduction of time keeper and how to handle timekeeper work and responsibilities I hope you will be provide to me
apaki video se bahut sikhane ko mila
Thanks
Sir ! Month ka overtime calculate karne ka tarika bataye ??
IN Time and Out time dalnekebad Regular time and OT apneaap calculate hona chahiye.
Out time Overtime included hona chahiye.
Bahut qoob
Useful👍🏻👍🏻👍🏻👍🏻👍🏻
Very nice
Bahut badhiya sir
I Am From Pakistan great work
sir apaki video se bahut sikhane ko mila
Good information one query solved. Hussh finally , I get it perfect video .nice job man..
Mere bhi overtime kaise nikalte hai ye to bataya nhi.. aap ne direct hours dal diye.
सर एक Digital Watch बनाये excel sheet में उस digital Watch की मदद से सबका attendence लगे attendence कुछ इस प्रकार रहे की ID no के साथ साथ नाम आने और जाने का एक sheet में Time सेव हो जाये एक तरफ से ये कह लीजिये की हमको attendence मशीन बन जाये और monthly attendence का रिपोर्ट्स भी मिले हम जैसे ही ID No टाइप कर Enter दबाये उसी क्षण IN OR OUT ऑटो सेव हो जाये और ओवर टाइम सब कुछ एक बार में निकल जाये
aap ki video bahut acchi
Nice video
Nice dipak j
Good Evening Sir,
Sir I want to know how to calculate the under noted problem in Excel :-
I have 12457 kgs coal want to calculate the time taken by a machine when output of machine is 1467 kgs per hr
Sir your all videos are very nice. Apki videos mei hamesha kuch new sikhne ko milta h. I like your videos.
OT is always calculated after 8hrs shift.
Sir pls correct your example data.
One practical error in your example
If any employee goes early he can not work overtime. Overtime is only when it worked 8:00 hrs in any industry
IT IS VERY VERY HELPFUL BROTHER PLZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ
Sir but jab ek sath 100 employees ka nikalna ho to ...
..
Sir ek video 10 employees ke uper bhi bana dijiye
Nice Video, good job Deepakji. Could you kindly provide a link to download spreadsheet used in this tutorial. Thanks.
Great video, very informative. I watch lot of your videos frequently, helps me a lot.
I have doubt :
Over time calculate karate samay Out time minus In time ka formula lagane ke baad agar OT 0:04 ya 0:18 ka hai to overtime 04 minute aur 18 minute ko pure mahine me jitane minute extra huye hai usako jodkar 3-4 ghante ka extra Monthly OT calculate karata hai to eisa na ho isliye 50 minute se kam ka time skip kar de aur 50 minute se jyada ka time 1 ghante me calculate (round up) kare iskeliye kya formula hona chahiye?
Hoping for a reply soon.
Thank you Sir.
Kya aap excel me job krte h
Waah Deepak ji maaja aa gaya public ko kya bewkoof banaya hai
Bhai mere jab out time 4:00baje ka fix hai aur wo 3:30 per out ho gaya to over time kahan se aaya
Over time karega to 4:00 ke baad out hoga tab Regular hrs jyada ho jayenge Total working to galat hi aani hai.
Maine aapko pehle bhi suggest kiya hai Video usi topic per banao jiski jaankari ho baaki loog bana rahe hai isliye taang adani hai ye to koi baat nahi hui
If a person is working in night shift for Eg: he starts his work at 9pm and ends the day by 5am in the morning.Hope to get the reply soon.Thanks.
Good Video how to calculate overtime hours
Congratulation Deepak bhai complete for 1k subscribe
Sir agr Hume excel me home tab me editing block me fill series option me weekday option ki trh holiday ko kitni taarikh hogi Saturday Sunday ki
Sir please btao na
Sir very good but do more clean video
Aap kahana kya chahti ho .....ooo
very nice
thanks sir ji
Very nice bro. Please upload more instructions thanks dear
+Asim Khan sure..
Guruji thanks. Aap school attendance sheet details se easy tarike se banana sikhaie. Radhe Krishna guruji.
Ok g
Thank you sir
hello friend me 24 hours h
time ha 8:30 to 20:00 is mes mujhe ( lunch time (-0.30) nikalna h or total hours
plz
Good
Sir projects me hum value ko lock karte hai. Kaise pata chalega ki kaun se value ko lock karna hai . Sir please reply mera exam hai.
Sir ji Please guide me if formulla applied ti time format Exampe my Question if worker work 12 hours benefit 0:30 Hours other wise -0:30 Hours
bahut acchha hai
THANK YOU SIRJI
Bahut achha sir
Thanku ❤
Thank you so much Sir ji
😊
Nice video sir
nice
Overtime u have added manually. If we wanna calculate thru excel formula then how
दीपक भाई ये बताइये कि जैसे 6 घंटे तक 200 रुपये मिलेंगे और 7वें घंटे से 300 मिलेंगे !! इसको कैसे कैलकुलेट करेंगे ??
Nice sir....tnx
This video is too good sir..
But, I have doubt that..Am to Am time calculate kase hota ha.?
Like 9:00 Am to next day 8:Am how to calculate correct working our..? Plz
than you sir
Sir nice vedio but agar bahoot saare employees hai aur unme se kisi ek ka calculate kaise krenge .....
Nice presentation,but need to know how we can add name ,date, overtime in single work sheet
💞💞💞👌🏼
Check krni ho to kya krna Hoga sir please reply me
i subscribed today, i like. just tell k agar 1 employee 1 day main 2 ya 3 dafa in out kre then kya karna hai?
Okaay. I ll try to publish a video with easy and perfect solution 😊😊👍
@@DeepakEduWorld plz must. i need a solution..
नमस्ते सर ,
आपके सब वीडियो बहुत ही अच्छे लगे है पर मेरे लिए एक खास समस्या है जो उम्मीद है कि आप जरूर हल करोगें....
जैसे मेने student mark sheet बनाई है
उसमे Students को कुस money गिफ्ट दिए गए हैं
जैसे .....36 अंक से कम fail है
45 अंक से कम है उसको 500₹,
50 अंक से कम है उसको 1100₹,
60 अंक से कम है उसको 2100₹,
75 अंक से कम है उसको 3500₹,
85 से कम है उसको 5000₹,
95 से कम है उसको 7500₹
इस प्रकार पुरस्कार दिया गया है
तो बताओ कि हमने total कितना रुपया पुरस्कार के रूप में दिया इसका कुल योग furmula के हिसाब से बताओ
Hi Deepak your chanel is super awesome.. I have learnt lots of tips and tricks of excel from you. Please provide some guidance if in case a company has twice shifts (morning and evening) how could we calculate regular hours and total hours if the evening shift time starts and end like (7:00 PM to 4:00 AM)... please suggest any solution of this issue thanks and waiting to see a new video of this asap :) thanks keep doing good work for everyone
Please make a full video on formatting tool
Thanks sir ji
Thank you. Sir
Bhut accha
very nice sir
Good Sir, this is very helpful for me, but I have a problem with the sheet, I want to calculation only 15 days only, how possible?
overtime hours auto calculate ho sakta hain ES Video mai mannual add kia hain overtime hours ko?
I like it
Sir मैं रेलवे में हूं।रेलवे में रात duty की गड़ना रात 22 00 बजे से सुबह 6 00 बजे तक की जाती है हमे केवल 22 00 बजे से 6 00 बजे के बीच night duty hours निकालना है इसमें दो डेट शामिल होंगी ।कृपया इसके लिए फॉर्मूला क्या होगा मार्ग दर्शन करने की कृपा करें
Bas thoda sa wait kijiye...
Possible download this video for practice ?
Nice Sir
nice video sir
Nice...
Nice video sir
But mujhe is tarh se formula batay jaise ki in time or out time me se over time nikale. Or mera time 8hrs ka hai.
Jaise ki in time 09:12am- Out time 09:00pm. Ab isme se 8hrs genral time jo ki regural time ho or jo bach wo over time.is tarh se koi for mula hai to batay please
th-cam.com/video/cqj1P5SvbNg/w-d-xo.html
Hi depak sir how min the lunch time.
very good info please send me more excel videos on different subjects
Thank you
Please visit our channel playlist
JAB HAM EXCEL SAET MIN SE CUL SAMAY MAIN SE DUTI SAMAY GATATE HAI TO EARMULA THIK NAHI BAITHATA HAI.
hi sir I'm so happy to seen your video.
Sarvesh Gautam thanks
Sir. May Bangladesh se. Mera Auto AM/PM nehi aa raha he. or regular hour bhi nehi nikal raha he. plz sir if you help me. Mere liye bohot acche hoti. Thank you sir . Apki is Unique video ke liye.
+Monirul Islam 👍👍👍
+Monirul Islam please watch complete video... And try again... And even let me know... After retry
Sir
Thank you for sharing this video
I have a question about calculation pls give me the answer how to calculate the hrs
For example - shift times start date 1/1/2018 time 10.30 am and close time next day 2/1/18 time 6.30 pm how to calculate the hrs time
Please sir iska ans
Hello Deepak, You done really good job with good mind. Thanks a lot . I have a query for you.
How can we calculate time when someone worked from 21:00 to 8:00 AM next day. Now, from :-22:00 to 06:00 AM next day morning it is calculate as night shift.
Then , how many hours he done night shift?
Time negative hone ke bad kaise shwo kare
Suppose
Working Time
1-8:30 am to 4:30 Pm
2-In time 8:30 am Out Time is 7:30pm
How to Calculate over time by Some Formula in 2nd option.
thanks sir
Pls maintain day and night duty add one click one page all worker attendance
Sir employee rest days duty only over time counting ksy kry koi formola batyy ( har employee ke alag alag rest hai )
Sir.. Please teach to calculate OT hours by formula
Ok g i will publish shortly