How to Calculate Hours Worked in Excel

[@emach07]

OMG!! I've been online now for almost 3 hours trying to figure this out. Watched dozens of videos, forums, and just once and for all wanted to figure this out after attempting it off and on for years. Thanks a bunch!!!!

[@soulmoonwriter7847]

This is by far the most useful video! It has taken me years to understand and apply time work hours formulas and breaks. All the other videos or tutorials I have seen in the past never stuck in my head and this one will forever be embedded in me Thank you🙌

[@redalikat]

Definitely the easiest video to understand how to do this! Thank you for making it simple!

[@mariyamalkatrempel9178]

Thank you so much for making a quick and easy to understand video. I watched many useless videos before I got to yours.

[@TEKNISHA]

Great to hear!

[@Jasmin_love90]

Straight to the point. The best one so far. Thank you so much sir

[@latoya528]

You are a God sent! Thank you so much! I have been searching for this tutorial for two consecutive days without getting much sleep.

[@bunnbunns]

Thank you so much! I almost gave up, beacuse I thought that I will never learn those tough formulas to do that. And now it is so easy. Thank you!!!

[@khushigupta6393]

Love it! thank you sir! i love learning about excel and various new techniques from your channel please do not stop making this content!! it is so helpful!!

[@jadesymons6848]

The most helpful video i have found to date! simple and straight to the point. Thank you Sir :)

[@codyhanthorn4270]

Great job on the IF statement. I like many don't use IF that often and needed help understanding it better. The issue is when the scenario of time is not filled in for example it will give a 24.00 as answer. Should the IF statement be modified somehow of E4=24.00, then not to display 24.00? I think this is where using two IF statements together would be done, but have not done that (yet)..ha.

[@TEKNISHA]

Happy to Help!! You can use the if statement to check if the cell is blank and then base your response on that.

[@AparnaSAnil]

Thank you for the crisp explanation..!!

[@TEKNISHA]

You are welcome!

[@perlaperez4809]

okay i have this, but i need to convert the .75 to read .45 in minutes. how do i do that? do you have a video on that?

[@oraibfarzaan]

Thanks a ton for your video finally it worked for me after checking multiple videos

[@TEKNISHA]

Glad to hear that

[@Infinity.God217]

We are calculating in hours, which has 60 min but excel sheet is showing 75 min and total is also based on 100 not 60 min as the excel calculate in that way.

[@gustavop7410]

Most helpful video, many thanks!

[@TEKNISHA]

Glad it was helpful!

[@humingbird2187]

Very clear and concise video. Thank you!!!!

[@SyedMohammedHassan]

Thanks a lot. To the point calculation.

[@yourFNnightmare]

Thanks this just saved so much time

[@coffeecodeweb]

Thank you for a simple straight forward video. Now I'm going to be able to track my own hours at work instead of asking that grumpy old man at work how many hours I worked :)

[@gerilong7380]

Nice and easy. Thank you

[@MaharLika-nw6jz]

Thanks! Great vid great help! I do have a question though. What if someone is on leave, how do I fix the #VALUE! error without removing the formula? #VALUE! error shows up if you put ON LEAVE/RESTDAY. If you leave it blank, the formula shows 24hrs automatically. Thank you!

[@TEKNISHA]

Happy to Help!! You can use the IFERROR formula

[@david_bensonux]

Very useful. Thank you for your effort

[@AntiSocialAries]

thank you so much sir. your video really solved my issue as i was struggling for hours.

[@chetanbsonawane]

This is exactly what I was looking for ❤

[@TEKNISHA]

Glad it Helped!!

[@CJJamieson-gq2tj]

I have a clear input icon . Makes it easy to start over on next employees time. I also have the payrate calculation in a box.

[@rahulchaudhari3254]

Sir, Thank you for the formula, best and easy way to calculate the working hrs.

[@kestrel114]

thank you so so much! ...this helped me

[@genpittam5675]

Thank you so much! best and easiest video!

[@Coquitlam2024]

thanks for this, but I have a question regarding the formula, how do I contact you and send you the sample which I want to ask? thanks in advance.

[@TEKNISHA]

You can ask your question here.

[@gershonodze4703]

Very useful. Thank you!

[@mohammadyousuf7113]

As you have written in first column "in time -08:00 am and out time -05:15 pm" then worked hours will be 09 hours 15 minutes.

[@AEMace069]

9:15 (9 hours, 15 minutes) is equal to 9.25 hours

[@FishBanana]

Yes, it is true 9 hr 15 min but the column calculated for hour only which is 9.25 hours.

[@teandreluta2039]

Just a quick question, hopefully you see this. What happens if there was no check in details EG if the cells are black? Applying your formula gives me a 24 result as no hours are calculated. Is there a If OR IsBlank function to make it a zero?

[@abeindamountain]

short and very useful. Thank you very much. Excatly what I was looking for!

[@TEKNISHA]

Great to hear!

[@abrarahmed3925]

what will be the formula if i want to convert it to minutes.

[@nixblossom5696]

Really cool sir... it was straight on point...

[@novaconetta1577]

WOW! Thanks didn't know that was possible. Huge help

[@maameleaa8407]

Thanks for your help

[@TEKNISHA]

Happy to help

[@कुणालकेपी]

What should be the Cell format for Check In and Check Out Cell?

[@roblouzon4811]

what is the format of the cells in column C and D?

[@MerT-v2h]

more pls, now i understand. Thank you

[@angelicamanaog9468]

This is very helpful. Thank you very much!

[@shashikumar-sh2hr]

great sir thanku so much

[@davidwilliams3553]

How do you do the above (with overnight shift), but include a lunch break in between start and end times?

[@brotherhood318]

Thank you so much, brother. MashAllah, that was good for me

[@toshinrock1165]

How do you add in the formula the break times?

[@DelToroIzzy]

THANK YOU!!

[@SlightlyOffThinker]

Thanks, it woeked me 🎉

[@SlightlyOffThinker]

Worked for me.

[@TEKNISHA]

Great!

[@janinejeschke88]

Thank you for sharing this!

[@subitchas125]

In what format does the check in and check out time should be

[@munnabhaishiyal]

Thank you ❤

[@nachecrunche]

Thank you!

[@RebelPrintMedia]

Thank you Nish you saved me time

[@moodkn]

great... Thanks...!

[@TEKNISHA]

You are very Welcome!!

[@BosGaurus05]

This is amazing

[@FairoosAAzeez]

Good explanation

[@haidertalib9206]

How can the cumulative time difference between (4:00 pm - 9:00 am) be collected at the end of a month? especially if you have 100 employees

[@pratickdas6544]

thank you so much sir

[@rahulmondal9418]

Bohut hi badiya

[@TEKNISHA]

Glad it Helped!!

[@figo1337]

thank you so much!

[@mass1308]

When I enter formula and enter it comes #value! How can I change?

[@alexsisto8780]

Maybe hours can not be calculated

[@sanjaykanna7310]

Formula is ok .but pls explain the terms cells values for identification .as that is times or minutes or seconds..

[@akilassif2921]

Thank you

[@subhasisgangopadhyay8076]

Nice one

[@lifemotif6033]

thanks!!!

[@TEKNISHA]

You are very Welcome!!

[@mdashrafulalamshahriar3587]

you worked on Monday from 8 AM to 5:15 PM so how could it be 9:25? it supposes to be 9:15?

[@attobrahprince5236]

25% of 1 hour = 15 minutes

[@nickvalera1017]

I believe this guy has computer programming background correct me if im wrong :) if else nested statement can be used in order to execute different results

[@mbehera009]

hi can you tell if some one not attend so how can will 0

[@DeanCook]

Thanks

[@TEKNISHA]

Welcome

[@lusmolina115]

Hi, How i can use this formula with 2 breaks.

[@VGPBNM]

Friday 8.75 Hours coming but 1hour = 60 min that means 9.15hours correct how to solve

[@harvi7106]

That’s very simple

[@minimol9230]

Please add overtime calculations

[@mayxie9]

How less break time of 0.75 hrs from each day?

[@anandpedia4697]

Excellent. My another doubt: How to deduct free days? Let's say, an employee doesn't work for 8 days in a month. Please write down the formula for me. :)

[@HODLHAHA]

How do we get the formula to subtract 30 minutes for lunch if over 6 hours are worked?

[@qusaishah8117]

Hi I need help I am doing night shift and I work from 8 pm to morning 9 am That's 13 hours. But when I enter my time in time sheet instead 13 hours it minus the hours it shows 11 hours . Can u explain please

[@steveroberts4523]

What’s the name of that application please?

[@vineetpandit6329]

This formula is not working

[@sunitasharma4532]

Yes , that's the issue with me too ,I am also searching for so many videos for this

[@sai_keerthi187]

Yes

[@shivarajun5885]

It's working, do the multiple after closing the bracket.

[@karlrovey]

Did you format the cells to properly accept AM and PM?

[@WTECHYT]

Jin ka formula work nai kr raha woh time ke baad space de kr AM aur PM likhen Example: 9:00AM wrong 5:30 PM correct 9:00SpacePM Tip: Ziada behtar yeh hai k aap manually AM PM na likhen Yeh option follow kren 👉🏻 number>Time>Select 1:30 PM P.S: Ab b agar tumhara formula work nai krta tou excel ko uninstall kar do tumhare bs ki na hai 😂

[@0s0sXD]

thanks

[@RonaldoRussellDesigns]

what if both times or in the am like 2:00am to 3:00 am

[@vaibhavchudasama9680]

1) 8h 30m 2) 3h 45m 3) 6h 50m....plz tell me formula to calculate this time for average.

[@JackChang2212]

Very helpful, Thank you very much🙏

[@ParthPoojary]

Please check your calculations, If checkin time is 8.00 am and checkout time is 5.15 pm than total working hours will be 9.15 hrs. kindly let me know if im getting something wrong

[@debajittayam5495]

If this really a correct formula? Because what I observed in this video is - On 1> Monday it's showing working hour - 9:25 (the correct WH is 9:15) 2> Friday- 8:75 (the correct WH is 8:45) 3> Saturday- 6:50 (the correct WH is 6:30)

[@TEKNISHA]

Yes. Since this is decimal calculation, 0.25 means 15 mins, 0.5 means 30 mins & 0.45 means 45 min

[@ArvindRajput-ps8tz]

To sir ji 8.75 min time hota h kya aapka check kijiye

[@TEKNISHA]

8.75 time means 8 & 3/4 hour, which is 8 hrs 45 mins.

[@AbdulHafeezMohammad-l2z]

Exact working hours not showing instead of 15 mins it's showing 25 mins

[@intellectualpeace7818]

how to calculate the hourly salary if evening time salary get increase by 2 euro pre hour , how we can tell excel that its evening time so calculate salary according to evening per hour salary

[@Kelemogile-p1g]

So 15 is rounded to the nearest number, not sure how to put it

[@mohammadyousuf7113]

please clear my point ma' am.

[@sanjumayuransi]

It seems that this calculation is wrong, although the working hours in the first row are sent as nine hours and fifteen minutes, but according to those formulas, it comes to nine hours and 25 minutes.

[@auraharry7990]

SIR, IN THIS SHEET MONDAY HOURS MUST BE 8:15. WHAT ABOUT FRIDAY ? 8.75????

[@TEKNISHA]

Since this is decimal calculation, 0.25 means 15 mins, 0.5 means 30 mins & 0.45 means 45 min

[@sandrarowland-munoz2291]

i have a value still and don't know what the problem is

[@TEKNISHA]

Please paste the formula you are using

[@ZOMBOLO]

what if the check out time was the next day?

[@wilbycadet906]

How can I get that excel sheet? Thank you

[@Nithiyananthan1]

Please check the table manually 8:00AM - 5:15PM = 9.15 8:15AM - 5:00PM = 8.45 7:30AM - 2:00PM = 6.30 I'm still waiting for the perfect formula or function 💯

[@pratubhagat884]

what about the 8.75

[@sftniausmn]

but what if they have a break when midnight shift? 😢

[@pakbet371]

How come the total hours from 8am-5:15pm is 9:25 and 8:15am-5pm is 8.75?

[@BHRCPolyclinic]

hOW TO CALCULATE MONTHLY IN-TIME & OUT TIME FOR THE STAFF....????

[@sanchaniyakomal5039]

Why we add 1in this formula

[@zxcvasdfg1789]

Why we add 1in this formula

[@maheshadhikarimack3994]

For Monday, 9.15 hours should be the worked hour..isnt it??