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!!!!

[@redalikat]

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

[@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🙌

[@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.

[@Jasmin_love90]

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

[@AntiSocialAries]

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

[@jadesymons6848]

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

[@angelicamanaog9468]

This is very helpful. Thank you very much!

[@novaconetta1577]

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

[@humingbird2187]

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

[@gershonodze4703]

Very useful. Thank you!

[@janinejeschke88]

Thank you for sharing this!

[@SyedMohammedHassan]

Thanks a lot. To the point calculation.

[@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!

[@RebelPrintMedia]

Thank you Nish you saved me time

[@genpittam5675]

Thank you so much! best and easiest video!

[@rahulchaudhari3254]

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

[@figo1337]

thank you so much!

[@AparnaSAnil]

Thank you for the crisp explanation..!!

[@TEKNISHA]

You are welcome!

[@nixblossom5696]

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

[@gustavop7410]

Most helpful video, many thanks!

[@TEKNISHA]

Glad it was helpful!

[@DelToroIzzy]

THANK YOU!!

[@nachecrunche]

Thank you!

[@oraibfarzaan]

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

[@TEKNISHA]

Glad to hear that

[@user-nd5el7qy1b]

more pls, now i understand. Thank you

[@FairoosAAzeez]

Good explanation

[@brotherhood318]

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

[@coffeecodeweb826]

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 :)

[@pratickdas6544]

thank you so much sir

[@chetanbsonawane]

This is exactly what I was looking for ❤

[@TEKNISHA]

Glad it Helped!!

[@BosGaurus05]

This is amazing

[@akilassif2921]

Thank you

[@maameleaa8407]

Thanks for your help

[@TEKNISHA]

Happy to help

[@sntbek]

Amazing

[@JackChang2212]

Very helpful, Thank you very much🙏

[@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.

[@0s0sXD]

thanks

[@rahulmondal9418]

Bohut hi badiya

[@TEKNISHA]

Glad it Helped!!

[@moodkn]

great... Thanks...!

[@TEKNISHA]

You are very Welcome!!

[@abeindamountain]

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

[@TEKNISHA]

Great to hear!

[@lifemotif6033]

thanks!!!

[@TEKNISHA]

You are very Welcome!!

[@SlightlyOffThinker]

Thanks, it woeked me 🎉

[@SlightlyOffThinker]

Worked for me.

[@TEKNISHA]

Great!

[@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.

[@subhasisgangopadhyay8076]

Nice one

[@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.

[@DeanCook]

Thanks

[@TEKNISHA]

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?

[@user-iq6zm5ts2b]

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

[@toshinrock1165]

How do you add in the formula the break times?

[@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

[@lusmolina115]

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

[@SERGIO-cr6uy]

Hi , since you seem to be an Excel Guru, i've a question that you may be able to answer.
is there a formula that add to something while keeping a previous calculation?
Let me explain what i'm looking for:
Let's say i have in cell A1 a value "100,00 hr" & in cell A2 "1,50 hr" (using decimal values with suffix, not hours / time / duration)
(meaning 1.50 hr instead of 1:30:00)
I want A1 to sum the added value every time i add something in A2.
Let's say monday i add 1,50 hr on A2, i want A1 100,00 hr to be be "101,50 hr"
Tuesday i write 2,00 hr in cell A2, i want it to sum up in A1 ( "103,50 hr")
Wednesday i write 5,00 hr in cell A2, i want it to keep summing in A1 ( = 108,50 hr)
etc.
First of all, is it possible to do this? and if it is, what would be the formula?
To be even more spécific i'm gonna use it on Google Sheets, hopefully , if there's a formula on Excel, Google Sheets will deal with it.
Thanks a million.

[@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

[@mohammadyousuf7113]

please clear my point ma' am.

[@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

[@minimol9230]

Please add overtime calculations

[@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.

[@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.

[@RonaldoRussellDesigns]

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

[@mass1308]

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

[@alexsisto8780]

Maybe hours can not be calculated

[@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

[@vaibhavchudasama9680]

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

[@steveroberts4523]

What’s the name of that application please?

[@pratubhagat884]

what about the 8.75

[@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?

[@wilbycadet906]

How can I get that excel sheet? Thank you

[@user-jj8xi6yd9y]

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

[@user-si8gf8xy7s]

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

[@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

[@didierGONCALVES]

interesting !! How to do the same between 2 dates and times ? eg 02/15/2023 08:00 and 02/20/2023 06:30

[@j.jarvis7460]

Ask Chat Gpt

[@sandrarowland-munoz2291]

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

[@TEKNISHA]

Please paste the formula you are using

[@erinusman378]

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

[@tonytaf107]

Any suggestions to covert for example: 1m 30s to 1.5 or 4m 30s to 4.5 ???? Please

[@MuhammadFarooq-ox6uq]

RIGHT CLICK ON IT AND CLICK FORMAT CELLS, CHECK IN TIMES SECTION. YOU WOULD FIND PLENTY OF TIME FORMATS.

[@ameenlawal6146]

How can wrench time be calculated on excel ?

[@qu33n-s]

I am getting an error: #value! ... maybe cause i alredy
have a formula on my cells to combine the date and
time !
I dont know .. please help me, I'm trying for the last 4
days 😭😭😭

[@AK-fr2ev]

Include our break hours 8.30 to 5.30. or else working hours only

[@sanchaniyakomal5039]

Why we add 1in this formula

[@zxcvasdfg1789]

Why we add 1in this formula

[@user-zl1ft4uf7o]

Why am I getting an error using this formula in 365?

[@srijansaha7212]

How come 75? when minute counting by 60?

[@user-ty1cv4oc7s]

Not working showing #value error

[@user-nn1sn8bl2q]

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

[@maheshadhikarimack3994]

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

[@madhusudhanthapa]

How to total

[@BrijeshKumar-ol3yx]

Sir how is possible 8 hour 75 minutes in E7 column?

[@TEKNISHA]

This is 8.75 hours which is 8 hours 45 minutes

[@jermy3219]

why did he add 1 why add twenty four hours before mutiplying by 24

[@arifeenzulkarnain5120]

Why 8.75 on friday ? Its not possible

[@user-zo5cc8vx4y]

On Friday the person has worked for 8.75 hours (????) what does .75 means in the clock?

[@TEKNISHA]

Hi. 0.75 (3/4) means 45 minutes.

[@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

[@sujalkumar6575]

Not calculating 12 am midnight to 12 am midnight into 24 hours it say 0 hours. Help please

[@May_1993]

Just use the formula he instructed and put: 12:00 am and 12:00 am on the cells.

[@maskridersupergold2501]

the correct is 41.30 hours,.

[@virajojha9252]

Why your first hour worked showing 10 minutes extra

[@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.

[@Aghubhai]

I could have been better if you say out time or in time instead of d4 c3

[@AbdulHafeezMohammad-l2z]

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

[@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

[@ranveerarya3955]

Nhi a rha h sir

[@bepractical8727]

8:00 am to 5:15 pm = 9:15 that's right but u write 9:25

[@sonyamoz9347]

It faster to do manually..

[@TEKNISHA]

That is true if you have only some rows. When there are many rows or if this is required multiple times, a formula will always make your life a little easier and is also error-free.