How to Calculate Overtime Hours in Microsoft Excel | Overtime Calculation formula in Excel

Подписаться 498 тыс.

Просмотров 327 тыс.

50% 1

In this video we will learn to Calculate Overtime Hours in Microsoft Excel step by step
#overtime
#overtimecalculation
#overtimeformula
#excel_overtime_calculation
#excelformula
#excelfunctions
#microsoft_excel_tutorial
#studyspan
Music: Outside
Musician: @iksonmusic
Thank you

Опубликовано:

4 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 82

@danzar713 9 дней назад

Good bro.

@KPKGeneralTransport 3 месяца назад

Hats off to you bruh from pakistan really helpful video

@AliBaba-xe5fq 8 месяцев назад

Thank you so much for uploading a perfect video to count the time in minutes accurately

@TanvirHossain-gd7zn 5 месяцев назад

this example was so simple yet so useful and effective, thanks a lot sir.

@dannanamohini9212 4 месяца назад

Thanku you sir use full formula

@manishmalik1719 3 месяца назад

SIMPLE AND BEST

@wasimalamansari7432 7 месяцев назад

Bhai 24hr ka btao. Night ka night out time ho to kese nikali 12Am k bad

@GODFREYMILES-vn9fr 4 месяца назад

Next time consider using English, don't limit your audience to only Hindi speaking people. So many people need to learn these things.

@Akashpandey-b4z 3 месяца назад

Angreji me sikhoga Sutari k

@arifmallick8384 10 месяцев назад

HELLO SIR THANKS FOR THE HELP IN THIS VIDEO, KINDLY ALSO GUIDE ME HOW TO CALCULATE SHORTAGE OF TIME ALSO.

@AjayKumar-xn3tk 3 месяца назад

Thankyou bro

@anilscorner3960 Год назад

Agar hum basic salary, allowance and overtime ke hisab se worker ne multiple projects par kaam kiya is trah salary count karni ho to kya hum per day salary ko present days ke sath multiply krte hai example we count 30 days for salary to worker 26 days present tha 4 holydays hai to overtime ki amount humko mil gyi per day ki amount hum ko mil gyi to kya hum total salary ko total present days ke sath taxeem kr k project wise present days k sath multiply krte hai to kya yeh formula sahi rahega project wise salary calculation ka

@Anthony-p1n3f Год назад

Very use full sir thank you🙏🌺

@jeevithjk6389 4 месяца назад

My doubt if the worker without completing there shift, how to calculate with nagative hours in single formula.

@bittu25 Год назад

Thanks for teaching

@islamulhaque123 Год назад

Sir bahut accah laga

@kash4177 3 месяца назад

If some employees are break duty, how can we count overtime and all.

@bantikhan8380 Год назад

Thanku sir

@StudySpan Год назад

You are mostly welcome. Stay tuned for latest videos

@wazeemakram6392 Месяц назад

When you mention scenario this option will not work if someone has worked next day continuously. For an example if a person logged in at 7 am today and logged out 1 am next day. Then this formula will not work.

@MEDIPLUSHR-zx5cy 5 месяцев назад

Thank u

@shahqasim8513 Год назад

Best videos , thanks 🌺🌺

@misamrazamamdani661 9 месяцев назад

If it is night shirf then what formula will apply ??

@parthopratimdas175 Год назад

Thank you sir

@StudySpan Год назад

You are mostly welcome

@rizwanahmed1103 Год назад

how to know if the worked hours is less than working hour

@topcomputergyan6774 7 месяцев назад

Thanks sir

@fardeenahmad2113 7 месяцев назад

Sir agar hum Ek din me 4 bar time kese calculate kare.. jese Morning se afternoon Tak afternoon se evening tak

@RavinderKumar-nq2up 8 месяцев назад

Es me lunch 30min ka lunch time cut karna he,

@Shehryarkhan38639 6 месяцев назад

Good Sir

@vijaydhavale3346 6 месяцев назад

🎉

@Farrukhabadi-z2e 2 месяца назад

In time ki formatting kya h

@TUNCENTRE 10 месяцев назад

Thanks

@RAMESHS-vf6vc Год назад

Tq sir.. ❤️

@RAMESHS-vf6vc Год назад

Nice vedio tq sir..

@naveenbhatt1451 5 месяцев назад

What about night shift there is no option for 24 hours

@rakeshmukhi9021 7 месяцев назад

Sir sab tikh hai per oar ek kaam kar dete to achha rahta..... Eske baad eska total over time amount kitna ban raha rs50 ke hisab se.... Eska formula dije please🙏🙏🙏🙏🙏🙏🙏🙏

@sanudas9768 Месяц назад

Night shift ka kaise karna hai?

@robiul_2.08 2 месяца назад

আমি একটা ফর্মুলা অনেক চেষ্টা করেও করতে পারছি না যদি একটু হেল্প করতেন তাহলে অনেক উপকার হতো। যেমন ধরেন, আমি যদি রোজ ১৬ঘণ্টার বেশি কাজ করি তাহলে আমার টোটাল কাজের ঘণ্টা থেকে ২ঘণ্টা মাইনাস হবে আর যদি, ১৬ ঘণ্টা বা তার কম কাজ করি তাহলে ১ঘণ্টা মাইনাস হবে। যেমন - সকাল ৮টা থেকে রাত ১২টা =১৬ঘণ্টা তাহলে ১ঘণ্টা মাইনাস = ১৫ ঘণ্টা। আবার, সকাল ৮টা থেকে রাত ৩টা = ১৮ঘণ্টা তাহলে ২ঘণ্টা মাইনাস হবে =১৭ঘণ্টা।

@shettykutti Год назад

How to calculate am 5.30 am to 2.30 am time diff . Bcz this showing ####

@powerofknowledge3050 9 месяцев назад

Salary per hours of over time?

@sajidkhan81 Год назад

If a person work 12 days and then avail 4 holidays ,how many calculate working days in a year

@KhattakComputer 9 месяцев назад

To calculate the number of working days in a year, you need to know the total number of days in the year and then subtract the holidays. Let's assume a standard workweek of 5 days (Monday to Friday). In a year, there are usually 52 weeks. So, the total number of working days in a year would be: Total working days = (Number of weeks in a year) * (Number of days in a week) Total working days = 52 weeks * 5 days/week = 260 working days If a person works for 12 days and then takes 4 holidays, you would subtract those days from the total: Remaining working days = Total working days - (Worked days + Holidays) Remaining working days = 260 - (12 + 4) = 260 - 16 = 244 working days Therefore, the remaining working days in the year after working for 12 days and taking 4 holidays would be 244 working days. Keep in mind that this calculation assumes a standard workweek and may vary based on local customs, company policies, and regional holidays.

@AnitaRay-pi3uq 2 месяца назад

Just use alt= to sum

@namitasingh841 9 месяцев назад

Montha ka kese kre sr plz video bano or usi salary sheet bhu ban jaye

@sunny320320 10 месяцев назад

Pure month ka kaisey ...?

@360highlights5 Год назад

How to minus lunch break time ?

@rivurajput07 Год назад

Time k sath number ko kaisa multyply kare 12:00*25

@RiteshKumar-ik7bb Год назад

हमे जानना है कि एक ही कॉलम में ओवर टाइम के साथ अगर किसी दिन वर्किंग ऑवर से कम काम मिया हो उसे भी कॉलम में जीरो शॉ कर इसका क्या फॉर्मूला उपयोग करे

@kamalnarayankhutiyare9258 Год назад

If formula

@dhrubbro7214 Год назад

Ye formula 2007 ms Excel mai kam nhi krta

@shivamsinghrajpoot9286 9 месяцев назад

Nhi ho raha h sir formula settings bhi hoga koi

@thaluya 6 месяцев назад

Are sir ye to kewal jada se kam me minus karke nikalta he

@mathewpereira-8583 Год назад

Hi hello I have Saturday hf day 8Am to 1 pm so what is the formula

@HarpreetKaur-gm3bl 9 месяцев назад

Right meri bi yehi problem h

@YouTube.D2e Год назад

Helpgul

@rheapeter9709 Год назад

Thank you sir!!

@sansannwe2067 Год назад

Thanks sir🙏

@litandebnath1 Год назад

Hello sir iska kasa Kara Exmp:- in time. Out time 07:20 08:40 12:60 15:10 Eska duty 8 hours ha 07:00 to 15:00 lakin eya pura nahi Kiya ha lakin kitna ghanta Kiya ha kasa Kara exal ma please bataya

@RajaVerma-fm9er 4 месяца назад

Sir ye Excel me kaam nhi kr rha hai ky kru bto

@StudySpan 4 месяца назад

Requesting you kindly video ko acche se dekhiae then apply kijiye

@RajaVerma-fm9er 4 месяца назад

@@StudySpan sir me aache se dekhne baad hi bol rhi hu iski koi setting hoti hai ky khibyr bata do ye kaam hi nhi kr rha

@muhammadariflari5587 Год назад

EXCELLENT

@binoyjohnson6112 Месяц назад

- time kesa nikla na ha

@AmanSharma-bf9yx Год назад

Kisi row me agar overtime nahi hai to zero kaise show krenge

@theburnedsun1813 10 месяцев назад

Yaar mera bhi yahi sawal hai

@Sanju_pahadi-u.k.04 Месяц назад

Total hrs m value error kyu ata h

@StudySpan Месяц назад

Requesting you kindly video ko acche se dekhiae then apply kijiye

@chandramasingh1815 Год назад

Sir mene avi kosis ki lekin total hours nehi nikla 😔😔

@zeeshan.writer2946 Год назад

contact me whatsapp

@suhaansingh1995 Год назад

Always Give space between time & AM, PM like 6:00 AM nikal jayga

@girishkamble5818 Год назад

[Hh]:mm

@soumenbhowmik616 Год назад

@@suhaansingh1995hua nahi

@VipinKumar-bk7ry Год назад

Goodnight

@saleemmohammad9534 10 месяцев назад

file link nhi hai

@Shajidulislam879 11 месяцев назад

❤❤AM PM Bajase #velue! Arahahe .kaise solve kornahe. AM PM Nahe dalenge to Ajateha. Ham Bangladesh se ho

@nagurichennakesavulu3705 Год назад

Creative and create design word Excel Power point use jobs Basic and advance online tutorial every day your channel me supported. Excel basic and advance tips trick please send me