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!!!!
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🙌
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!!
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.
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.
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?
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!
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 :)
What about Friday 8.75 hours meaning. Time is only till 60 minutes. Please clarify. Also explain if I want to calculate over time after fixed 8 working hours.
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)
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 😂
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. :)
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
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
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.
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
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
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!!!!
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🙌
Thank you so much for making a quick and easy to understand video. I watched many useless videos before I got to yours.
Great to hear!
Definitely the easiest video to understand how to do this! Thank you for making it simple!
Straight to the point. The best one so far. Thank you so much sir
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!!!
Most helpful video, many thanks!
Glad it was helpful!
You are a God sent! Thank you so much! I have been searching for this tutorial for
two consecutive days without getting much sleep.
Thank you for the crisp explanation..!!
You are welcome!
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!!
Very very useful.. thank you so much ❤
Thanks a ton for your video finally it worked for me after checking multiple videos
Glad to hear that
The most helpful video i have found to date! simple and straight to the point. Thank you Sir :)
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.
9:15 (9 hours, 15 minutes) is equal to 9.25 hours
Yes, it is true 9 hr 15 min but the column calculated for hour only which is 9.25 hours.
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.
Happy to Help!! You can use the if statement to check if the cell is blank and then base your response on that.
Very clear and concise video. Thank you!!!!
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?
Thank you so much for valuable information dear
Thanks this just saved so much time
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.
Thank you,
well explained.
thank you so much sir. your video really solved my issue as i was struggling for hours.
Sir, Thank you for the formula, best and easy way to calculate the working hrs.
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.
This is exactly what I was looking for ❤
Glad it Helped!!
you worked on Monday from 8 AM to 5:15 PM so how could it be 9:25?
it supposes to be 9:15?
25% of 1 hour = 15 minutes
thats true he totally put the wrong value and it should be 9:15 why is it 9:25 ? im still wonder
Very useful. Thank you for your effort
What should be the Cell format for Check In and Check Out Cell?
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?
Thank you so much! best and easiest video!
Very useful. Thank you!
Thanks a lot. To the point calculation.
WOW! Thanks didn't know that was possible. Huge help
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!
Happy to Help!! You can use the IFERROR formula
Nice and easy. Thank you
Really cool sir... it was straight on point...
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 :)
thank you so so much! ...this helped me
How do you do the above (with overnight shift), but include a lunch break in between start and end times?
This is very helpful. Thank you very much!
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.
You can ask your question here.
more pls, now i understand. Thank you
what is the format of the cells in column C and D?
How do you add in the formula the break times?
short and very useful. Thank you very much. Excatly what I was looking for!
Great to hear!
what will be the formula if i want to convert it to minutes.
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
Friday 8.75 Hours coming but 1hour = 60 min that means 9.15hours correct how to solve
Thanks for your help
Happy to help
In what format does the check in and check out time should be
Thanks, it woeked me 🎉
Worked for me.
Great!
Thank you so much, brother. MashAllah, that was good for me
What about Friday 8.75 hours meaning. Time is only till 60 minutes. Please clarify. Also explain if I want to calculate over time after fixed 8 working hours.
When I enter formula and enter it comes #value! How can I change?
Maybe hours can not be calculated
Thank you for sharing this!
Thank you Nish you saved me time
Bohut hi badiya
Glad it Helped!!
what about the 8.75
Formula is ok .but pls explain the terms cells values for identification .as that is times or minutes or seconds..
hi can you tell if some one not attend so how can will 0
How do we get the formula to subtract 30 minutes for lunch if over 6 hours are worked?
How come the total hours from 8am-5:15pm is 9:25 and 8:15am-5pm is 8.75?
great sir thanku so much
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)
Yes. Since this is decimal calculation, 0.25 means 15 mins, 0.5 means 30 mins & 0.45 means 45 min
How less break time of 0.75 hrs from each day?
This formula is not working
Yes , that's the issue with me too ,I am also searching for so many videos for this
Yes
It's working, do the multiple after closing the bracket.
Did you format the cells to properly accept AM and PM?
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 😂
Thank you.
Good explanation
THANK YOU!!
SIR, IN THIS SHEET MONDAY HOURS MUST BE 8:15. WHAT ABOUT FRIDAY ? 8.75????
Since this is decimal calculation, 0.25 means 15 mins, 0.5 means 30 mins & 0.45 means 45 min
great... Thanks...!
You are very Welcome!!
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. :)
i have a value still and don't know what the problem is
Please paste the formula you are using
Thank you!
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
Thank you ❤
Please add overtime calculations
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
To sir ji 8.75 min time hota h kya aapka check kijiye
8.75 time means 8 & 3/4 hour, which is 8 hrs 45 mins.
thank you so much sir
thank you so much!
what if both times or in the am like 2:00am to 3:00 am
So 15 is rounded to the nearest number, not sure how to put it
How come 75? when minute counting by 60?
Definitely how??
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.
Hi, How i can use this formula with 2 breaks.
Thanks
Welcome
Exact working hours not showing instead of 15 mins it's showing 25 mins
but what if they have a break when midnight shift? 😢
This is amazing
what if the check out time was the next day?
What’s the name of that application please?
thanks!!!
You are very Welcome!!
1) 8h 30m 2) 3h 45m 3) 6h 50m....plz tell me formula to calculate this time for average.
Thank you
Why we add 1in this formula
Why we add 1in this formula
how to calculate overtime
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
Nice one
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
interesting !! How to do the same between 2 dates and times ? eg 02/15/2023 08:00 and 02/20/2023 06:30
Ask Chat Gpt