Thanks a lot, Long time searching for this option.
@tonystark-kq2dl Жыл бұрын
i love you already, you just saved a graphic artist whos trying to learn another job.
@joshbracken54508 ай бұрын
Thank you so much. I searched through so many videos for this answer. Thanks again!!
@oldtrojanskin2 жыл бұрын
You Sir are the Boss. My finish time is midnight and this formula worked fantastically. Thank you for this video.
@natasjavanstaden1537 Жыл бұрын
THANK YOU, THIS WAS SO EASY TO FOLLOW, AND TO APPLY TO MY WORK SHEET, THANK YOU AGAIN
@theplunge37623 жыл бұрын
Thank you this helped so much, I am a nightshift nurse and this spreadsheet helped me find some missing hours in my paycheck!
@philbrenman25074 жыл бұрын
I have followed your instructions to the letter and I continue to get an Error popup. Very frustrating.
@nauruakoura22282 жыл бұрын
this was very helpful in fasten my work while working with hours of shift staff for Appraising purposes mainly in the analyzation of their attendances.... Well done
@MedooWolf4 жыл бұрын
Try the “Mod” function for example =mod((time out - time in),1)
@ExcelTutorialsEasyClickAcademy4 жыл бұрын
Moh'd Wolf thank you for your tip :)
@MedooWolf4 жыл бұрын
Excel Tutorials by EasyClick Academy Thank you actually not me 😇
@MrTruckdriver663 жыл бұрын
moh`d Wolf, to be honest with the with the =IF function the daily time came out well, but on bottom the Sum didnt work, shows stupid values no matter how i set in cell format. i tried your =MOD funcition and it works correctly thanks very much
@MedooWolf3 жыл бұрын
@@MrTruckdriver66 great 👍🏼, our company have people working days and nights so whenever i use IF function on night times it gives me some kind of error, so that i used MOD function.
@shahjalal8773Ай бұрын
Thanks a lot from Bangladesh ❤️
@SoMuchLoveee29Ай бұрын
SOOOOOOO GOOD! Bless your heart
@rajkishorebehera729 Жыл бұрын
Very useful thank u sir😊😊 I was tensed from yesterday and now I am relaxed 😘😘
@sweetvuvuzela4634 Жыл бұрын
Awesome
@rexx3574 Жыл бұрын
Dude, u saved me so lot of time! ❤ u got a new loyal subscriber. 💋
@akkiannetolentino3512 жыл бұрын
thank you so much, im suffer this for how many years to. make my time sheet when comes to overlapping time.
@Zlx14 жыл бұрын
This works perfectly, but i have a different problem related to this. If say the work hours are from 17:00-07:00, with this tutorial it totals at 14 hours which is correct. But what if i want to automate the total amount of hours worked that has elapsed 18:00 but within 06:00? Where I'm from we get paid extra for the hours worked passed 18:00 and stops after 06:00, so with my 14 hours worked only 12 hours are within that time frame. Is there a formula for this?
@alanw64 Жыл бұрын
Very clear and easy to understand - thank you!! 🙏🏻
@rjrustam88282 жыл бұрын
Good explanation, Thanks
@chaithanyaasokan16524 жыл бұрын
This was very helpful to understand timesheet... is there a video on salary calculation?
@UnoSonu192 жыл бұрын
Thank You very much for this video
@diamondbreak2 жыл бұрын
You are such a life saver! tons of thanks.
@sohaibzaman29995 ай бұрын
Thanks for this video ❤
@AliAbbas-uh4oy3 жыл бұрын
Thanks, sir, very informative video.
@ramonperez98212 жыл бұрын
Amazing information Thanks!!!
@garethgordon9141 Жыл бұрын
Very clear and much appreciated 👍🏻
@jamesiyog7542 Жыл бұрын
Thank so much sir.
@aikching1aikching1563 жыл бұрын
Thank you .. Help me a lot
@vanz13-4010 ай бұрын
Hey there great video found one problem with the equation if the clock in time is 6:00 Am and clock out time is 6:00 Pm the same time but am and pm the output would be 0.5 to fix this problem I used this equation =(IF(D4>D5,D5+1,D5)-D4)*24 this will return the right output. Just add the times 24 at the end to fix this problem. Furthermore this equation does no work for 24 hours shifts which I doubt people do but it a thing. Again Great video just trying to provide more help.
@unitedummah728 ай бұрын
Thnx man i got a solution from comment section instead of video😅
@taypaddy4 жыл бұрын
What about Formula to determine the starts or the end of Hour in 8 hour worked. Like if I started 8:35 AM but I have to worked 8 hours, what time should I end? Thank you and regards.
@dytjayasinghe3 жыл бұрын
Thnx its saved my time
@WalkingBird1972 Жыл бұрын
Thank you very much...
@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.
@markjones30884 жыл бұрын
Chers frank you saved my life xx
@ExcelTutorialsEasyClickAcademy4 жыл бұрын
Mark, it's been a pleasure helping you. Thank you for your feedback. :)
@soumiamoujane36952 жыл бұрын
Thank you for this video. Very helpful and useful.
@syedmubarakbasha43773 жыл бұрын
thank u very Much sir such a great video.
@shalyarkh2633 Жыл бұрын
Thank a lot
@adlenemarsita26372 жыл бұрын
Awesome! Thank you for making it so clear
@digitalmarketingtipps3 ай бұрын
thank you.
@ultra3322113 жыл бұрын
Thanks for the video, of the topic -by the way which video editor was used to create this video - speech to text is fabulous if any one read this comment and if know the answer - please answer my question
@taypaddy4 жыл бұрын
What about formula in determining the Time Started or the Time ended with the given Total hours is 8 hours. Example, I started 6:00 AM and ended in 2:00 PM, what would be the formula to that? Thank you and regards.
@HankMegens3 жыл бұрын
Hello, How do you calculate this, working with a 24 hours clock instead of AM and PM hours?
@beversl22 жыл бұрын
This was amazingly helpful!
@christellelafrance37063 жыл бұрын
Thank You.
@xavierfranzvicente59402 жыл бұрын
Hi! just a question can you show us how to deduct hours on any time for example 1 want to deduct 2 hours from 12:00am or 1am hope you can helps us Thank you! more power
@vidyadharvm41322 жыл бұрын
Thank you
@BABALORECABLETV4 жыл бұрын
hey am impressed with tutorial. Could you please do a tutorial of lets, an employee starts work 7am and goes for normal shift of 8 hours until 4pm, then again starts another over time shift from 7pm to 3am . please am stack help a brother.
@NZee15 ай бұрын
I need to understand how 'End Work + 1' is calculating the total hours worked. Please explain.
@tension0.24 жыл бұрын
thank you so much for your lovely helfull video
@gtdodgeviper2 жыл бұрын
How do i subtract lunch on the same time. Do i just add -30
@mr.mughalll2 жыл бұрын
Thanks
@mufycw2 жыл бұрын
your formula gives wrong output when you try to total the hours worked for more than one day. For example if a person has worked 13:57 hours and another day 11:48 hours (this hours I am getting using your formula) then total shows as 73:45 hours instead of 25:45 hours. Any suggestion?
@ahomparth Жыл бұрын
thanks👍
@atulshukal40723 жыл бұрын
Yes very good Sir
@markheatherington83678 ай бұрын
Thanks man'!!
@stevedavenport93653 жыл бұрын
This is somewhat helpful. What if the time is 6:00PM to 06:30AM?
@caressowens92803 жыл бұрын
What if it does change after copying the overnight formula to the other cells? Mine changed, but before it changed the formula was accurate. I just clicked the reverse command to correct the change.
@ShouvikDe Жыл бұрын
Helpful
@shoremedic Жыл бұрын
What if the start time is not greater than the stop work time even if they span midnight? I worked from 18:58 to 07:01, which would negate the described logical test.
@maroofaziz5045 Жыл бұрын
Hi Any possibility you could help with how to add an IF BLANK clause into this formula? would appreciate it :)
@maroofaziz5045 Жыл бұрын
Figured it out. It required an IF rule within an IF rule :).
@patriciailin13692 жыл бұрын
Can I somehow calculate hours worked between 5:03PM to 08:30 AM, if the business hours to be calculated are 8:00-5:00PM?
@mdrubelrubel31152 жыл бұрын
Nice video
@cmarin91093 жыл бұрын
How could I fix a problem, I have a worker who started 11am in the morning , and finished working 12am at night
@Incognit07772 жыл бұрын
Good video, I mostly got the way it was presented. However, I missed the logical step behind the "+1" in the formula. Does Excel read it as "+1 day" as initially I thought it would read it as "+1 hour" and was wondering how it would work logically?
@donalodomhnaill2 жыл бұрын
Yep, it is actually a terrible discription in that, well, it actually wasn't described at all! Pretty rubbish tutorial if they thing you are teaching leaves you with more questions. Makes me think the person does not actually know what they are doing and is himself just coping someone elses tutorial.
@gigioz74 Жыл бұрын
2:36 tells you what the +1 means.
@mehedis759 Жыл бұрын
finally it's found
@fourteen90765 жыл бұрын
You are a live saver, thank you
@ExcelTutorialsEasyClickAcademy5 жыл бұрын
We are wery happy, that our tutorial helped you :)
@arjan19712 ай бұрын
Doesn't work in all Excel settings.. I need to use the ";" formula separation instead of ","
@sheftelyroosje2808 Жыл бұрын
how can you subtract break from it ?
@karthikthepulsarian97303 жыл бұрын
That was helpfull
@MultiSciGeek Жыл бұрын
Can I get the formula for decimal please?
@shahzadsami56133 жыл бұрын
WaoW Great Sir
@marcuspow3 жыл бұрын
Sir, if the work start at 6: Am and end at 11: 30 Am. How to I calculate?
@vishnuramesh88054 жыл бұрын
Elapsed time contains AM or PM!! What to do?
@cduanetech44912 жыл бұрын
help please .. formula start work end work = hours work.. (1.5) for "1hr 30mins" ...tnx .
@kinderjojomojo9 ай бұрын
hhmm whats the formula for 6:00AM minus 10hours??
@harisbasir59023 жыл бұрын
You can use Mod Fuction =Mod(D7-D6,1) enter
@petrupietersen61162 жыл бұрын
Hi, how can I work it out with the modfunction with the following as an example: I work from 22:00 pm (time in) until 00:30 (time out) or 6 May 2022 23:50 (time in) until 7 May 2022 00:10 am (00:10: 10 minutes past midnight)(time out)? Thank you.
@chaudhryjunaidashraf25483 жыл бұрын
Thumbs Up ! Thanks :)
@CambodianTutorials3 жыл бұрын
thanks
@naeemabbas48893 жыл бұрын
Sir am want to calculate hours But not understanding how can i do Sir please chek explained bely Start time 6:00 am End time 8:30 pm 1) 5;40 2 )6:30 3. )7:10 Sir please help me
@justanothercuriouscat3 жыл бұрын
what if with breaks and lunch time?
@Xavaltir4 жыл бұрын
hi, i have an issue when clicking on the 3th cell i need i get the error message does anyone know to fix this?
@ritesh04802 жыл бұрын
How it works to calculate with 24 hours clock instead of AM and PM hours?
@sweetvuvuzela4634 Жыл бұрын
Multiply by 24
@RajSharma-ct2xe4 жыл бұрын
Thanks a lot... :)
@gigioz74 Жыл бұрын
I'm finding in my 2021 version of MS Excel I'm left with a percentage rather than the number of hours:mins (eg 0.33 instead of 8hrs). Can someone please tell me how to add *24 to the formula so it can display the number of hours.
@mr.a_a9407 Жыл бұрын
Try changing cell formatting from percentage or general to Time format
@rayvanrensburg933 жыл бұрын
Good Day, My Question is, How do I change this in my time sheet calculator if this is in my cell and part of the validation code. need to modify this so I can still calculate the hours if it is night shift and not day shift starting from D17 to change to in time at 18:00 and out time at F17 to deduct it from E17 =IFERROR(IF(AND(D17"";E17"");IF(D17>$C$12+TIME($D$12;($D$12-INT($D$12))*60;0);0;IF(E17>$C$12+TIME($D$12;($D$12-INT($D$12))*60;0);MIN(TIME($D$12;($D$12-INT($D$12))*60;0);($C$12+TIME($D$12;($D$12-INT($D$12))*60;0)-D17));MIN(IF((E17-$C$12)
@ased786 Жыл бұрын
This does not work when, example: You start work at 6am and finish at 6am the next day
@innocentmunda5302 Жыл бұрын
What if we require in this list Only minute in a row..... 00:05 How to show 5 minutes in this
@moinmohammed4u3 жыл бұрын
HOW ABOUT THIS EXAMPLE :- CELL A (9:00AM - 1:00PM) CELL B (5:00PM - 10:00PM) HOW TO CALCULATE
@hamzamirza50283 жыл бұрын
Can anyone tell me how to use same formula for multiple cells?
@sweetvuvuzela4634 Жыл бұрын
Copy paste the formula only
@waqaszamanofficial14 жыл бұрын
Very helpful appreciate.... 🇵🇰🇵🇰🇵🇰
@ExcelTutorialsEasyClickAcademy4 жыл бұрын
Great to helped you :) Thanks for your feedback :)
@mahmoudelkheshen46153 жыл бұрын
Thanks, is +1 means 12 hours.
@djstevie692 жыл бұрын
Had a start time of 15:00 and an end time of 00:43, no matter what using this IF command I get a working time of 00:43.... Sigh... Stuck :D
@freedom_at_the_cross7 ай бұрын
didnt work gave me some random hrs
@avinashmajhi25105 жыл бұрын
Great
@ExcelTutorialsEasyClickAcademy5 жыл бұрын
We are happy, that our video tutorial helped you :)
@joeyhdplays8870 Жыл бұрын
Gave me an answer but that was incorrect and then mate all the right answers wrong