Calculate Time Difference in Excel

[@MChinwala]

Thank you very much for the very nicely presented video to the point. I liked how the + "1" pops up on the side. I think you prepared very well to present the video. Greatly appreciated.

[@AbhijeetKumar-fv4po]

Well done man ! I like your pace. I also like your approach to include wide set of learners and the issues they may face. Simplified explanation with highlighting of issues we may face is great. Subscribing !

[@Syedhussainipage]

Thank you for the feedback Abhijeet, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@junaidmuhammad996]

Love you man. Was suffering from long time Thanks a lot

[@Syedhussainipage]

Thank you for the feedback Junaid, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@BenDieselBasicAutomotive]

Wow!.. thanks for the knowledge gained...

[@Vivekmsd7]

how you calculate from PM to AM ? like 11.30 PM to 1.30 AM ?

[@BrokenRecord-i7q]

Thanks a lot, this really helped in a job related assignment!

[@venkatrao2175]

Superb .. Before I don't know how to calculate.. now I easly calculated..thank you so much Sir..

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@tintin6517]

very cool .. love the Ctrl/1 trick .. thanks

[@asahmeedsalih]

very useful and clear explanation

[@gamingalltheTIME497]

Thank you so much. It really helped me to complete one of my TAT report. 🙂

[@ActivityMinistry]

Thumbs up my friend. Just what I needed. Thanks for sharing.

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@DuchessScourge]

Super thank you, sir!

[@Syedhussainipage]

You are strongly welcome! and thank you for the feedback Duchess, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@conandis5542]

Thank you so so much 👍👍

[@Syedhussainipage]

You are strongly welcome 😊 I'm so glad to hear that. 🥳

[@jomurillo22]

Great lecture on this calculation. Thank you for your time!

[@jomurillo22]

But one question, how would you total the time spent column?

[@Syedhussainipage]

Thank you for the feedback Jose, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@Syedhussainipage]

@@jomurillo22 you may find this video helpful to calculate sum of time spent kzbin.info/www/bejne/lXPTlqBsh6qeZ9E

[@jomurillo22]

@@Syedhussainipage Just did, because these videos are close to a college level class!

[@Syedhussainipage]

@@jomurillo22 i hope you are finding them helpful.

[@mustafakamal9624]

Wow! Excellent explain👍

[@Syedhussainipage]

Thank you for the feedback Mustafa, it helps in keeping me motivated. Please subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@mustafakamal9624]

Sir, I subscribed to your channel as soon as it started to this video...

[@davideastham]

Thank you for the great explanation. I also am trying to calculate times that include a time zone. Is that possible?

[@Syedhussainipage]

Thank you so much for the helpful feedback. Yours is the first comment of 2023, thank you. Yes, you can calculate time based on timezones. Press share sample data so I can take a look. Use this form to submit your sample data file forms.gle/CxaWGeqdugMktWPx6

[@shashikamadhushan4396]

Thank you very much ❤️

[@Syedhussainipage]

Thank you for the feedback Shashika, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@nsfab265]

thank you so much for the easy solution

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@jackssparrow1232]

How did you get the Time for the Date AND the Time. I can't find a setting that supports both. And when I combine them it says #VALUE. So not sure what to do

[@MrBat000]

Awesome video!! thank you for sharing

[@Syedhussainipage]

Thank you for the feedback Mr Bat, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@najib6415]

Thank you very much, it is very easy and useful.

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@sravandhuduri]

Very good explaination.. Pls can you tell us how to convert that total hours in to no.of days..

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Divide the output by 24 to convert it into days. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@marwamoner1453]

can we find the difference time , avg, mini, maxi time between two columns time depending on specific (string ) in another third column ? please I need help , thanks in advance

[@vinay97077]

I like it it is simple thank u sir

[@Syedhussainipage]

You are most welcome

[@byg4you]

Hi, first thanks for sharing with us, I still have a question, what formula can I use for timing spend on specific work, I want to know the variance between actual time and expected time, thank you

[@alicetogonon2540]

Thank you so much! This will help me a lot to keep track of my AHT per process at my work 💖

[@Syedhussainipage]

Thank you for the feedback Alice, it helps in keeping me motivated. I'm so glad that you find the video helpful. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@nokpiadariusconstantino1333]

Ивбикьокж ащдцзхххцхзущлещлокдкотклкл

[@nokpiadariusconstantino1333]

@@Syedhussainipage вгдужьызцжжцжуднуликгрушнклзуззвтгетпктрклокззззузул удщзоуктоктоущущщузуззу

[@glen8607]

How to calculate the difference between 2 date/time ranges in business days? For example, cell A2: 07-Jul-23 18:00hrs and B2: 09-Jul-23 10:00hrs The result in C2 should reflect "00 Days 06 Hours" since Saturday and Sunday must be completely excluded in the calculation. I tried all possible options including chat GPT but failed

[@applejuice0134]

Thanks!

[@Syedhussainipage]

You strongly welcome Eric 🙏

[@omairosmani4259]

Wow.. That was easy! Thanks

[@Syedhussainipage]

I am glad you found it easy and helpful. Do not forget to subscribe to my channel and enable notifications for continued learning. Best Regards, Syed H | TechnicalSupport.blog

[@cathappytimes]

Thank you very much

[@sushmithapawar1221]

Tq it very useful and for the same I was looking for........

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@unnikrishnansanthosh]

excellent explanation, thanks a lot . will it be possible to calculate time duration of different time zone , for eg: to calculate flight travel duration

[@soulchemy6651]

Did you set any format to write the Date and time together? Or just a normal writing?

[@ashutoshvarshney914]

How to exclude Downtime or Non-working hours from two different dates & time while calculating Time Spent? Please help.

[@hemanthkumar4870]

Thank you bro

[@ItsReuben2You9685]

Hello. I watched your video and tried to modify it to fit my needs, but I can't figure it out. I just need to calculate the difference between two times that includes milliseconds. For example, how would I make an excel table that calculates the amount of time that has elapsed between two times like these: Time 1 (00:00:15:00) and Time 2 (00:00:16:15) . I am not concerned at all about dates. I just need to calculate the time difference. Could you assist me with this issue please?

[@Syedhussainipage]

The same technique should work, however, you need to use proper formatting. Kindly use the format as [h]:mm:ss.000 To apply the stated format, please press CTRL+1 on your keyboard and select Custom from your left side panel and enter the value from in type field. Refer this image drive.google.com/file/d/1mDDGToVpuX_Dx-VOTfaQH8KYJMzxmQCR/view?usp=sharing Do not hesitate to respond or contact me on Hangouts [[e-mail]] In case you need further assistance. Hope this helps. Best Regard, Syed H | myknowledgeportal.com/

[@ItsReuben2You9685]

@@Syedhussainipage Thank you for your fast replay. I really appreciate. I changed the format as you instructed and then clicked on cell b14, hit "-" then clicked on cell a14, then hit enter. I still keep getting "#VALUE!" I really don't understand what I am doing wrong. This is a simple formula, but I can't get it to work. I also sent you an invite on hangouts. I await your reply. Thank you!

[@Syedhussainipage]

@@ItsReuben2You9685 Did not see any invite on Hangout [hangouts.google.com/?authuser=1]. Please try again with [e-mail].

[@Syedhussainipage]

​@@ItsReuben2You9685 Happy to hear that. In case you haven't already, please subscribe to our channel and click on the little bell to enable notifications for new content. Best Regards, Syed H | MyKnowledgePortal.com

[@ItsReuben2You9685]

I finally figured out my error. I did not format the values in all three cells ( Time 1, Time 2, and Time Difference) to the format you instructed. I only reformatted the Time 1 and Time 2 cells. I don't know why I did not gather that I needed to change all the times to this format. But I figured it out. Thank you kind sir for helping me out with this. I have been searching for a solution to this for a long time. Now I can move on with my life. Thank you!

[@basu.31]

Thank You Sir...

[@production.coppergat]

CAN YOU HELP ME HOW TO SHOW THE FOLLOWING GIVEN BELOW; 8:15AM TO 8:30AM MENTION -1HOUR, 8:31 TO 9:00 MENTION -2HOUR, 9:01 MENTION -4HOURS, 12:00PM MENTION -4HOURS, 3:00PM MENTION -2HOURS, 4:00 PM MENTION -1HOURS ALL THIS IN ONE CELL IS THERE A WAY?

[@Ismail-Yahya]

What would you do if you wanted the cell to automatically calculate this time difference; but when the cell is empty you do not want there to be any error message in the cell. So the formula is their and automatically calculates time upon entry of data.

[@hammadshams]

Thank you sir, you have been very helpful

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@adityazaware9997]

I was calculating the time for 12 hours and it shows 00:00 (zero minutes and zero seconds) how do we correct this to 12:00 hours

[@Gk_Garden]

22 april 2022 morning 8.20am & 24 april 2022 morning 8.20am how to calculate to be between hours in ms excel

[@Gk_Garden]

Anybody plz reply

[@TheAndrevdw]

I cannot read the custom setting you use when time is calculated over more than one day.

[@SHIVERSMAGBYRNE]

How do I calculate the date and time of lateness:- 11/01/2022 09:10 11/01/2022 10:30 I need to work out how many HH:MM the clinic started after core start time of 08:30

[@dineshmishra-rh3yx]

In the second example, if we have to exclude weekends how can we do that

[@Syedhussainipage]

Please check out this video and let me know if that helps: kzbin.info/www/bejne/n2LSeGt-oNWmeKM

[@thanaponnupinit2734]

good job bro

[@Syedhussainipage]

Thank you for the feedback Thanapon, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@nusulasarahnamukasa4578]

❤❤❤❤great

[@nusulasarahnamukasa4578]

The pace is toooo good for learners and no step is left out. Thank you ❤

[@babam5792]

I want to calculate end time based on total time spent in the task. For example, a task took 45 mins to complete, the end time should be start time + total time spent. That is what I know, but if the end date moves to the next day then this formula does not work

[@thomasmccourt892]

Is it possible to calculate time difference when the start and end times are in the same cell? Eg 12am-8pm in cell A1

[@Syedhussainipage]

It is but with a little trick. Share the sample data and i can try something.

[@chandrashekarreddychennara5403]

hi actually need some help from you if I'm Using If Function =IF(V2=B5,F5," ")&IF(V2=B6,F6," ") like this to display 2 different timings in single cell it's showing like 0.3750.520833333333333 instead of 09.00AM,12.30PM can we fix this ?

[@Syedhussainipage]

Hey Chandrashekar, Can you please try =TEXT(IF(V2=B5,F5," "), "H:MM AM/PM")&", "&TEXT(IF(V2=B6,F6," "), "H:MM AM/PM") Let me know how it goes.

[@Syedhussainipage]

Did the solution work?

[@tevinkioko8668]

What of incase start date and start time are in different cell

[@Syedhussainipage]

Hey Tevin, Thank you for your message. Can you please share a sample data so that i can take a look at it to help you with that? Use this form to submit your sample data file forms.gle/CxaWGeqdugMktWPx6

[@ahammadali4440]

Awesome. Thanks

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@muthusuthanradhakrishnan5542]

I have one small doubt, assume 50 apartments having move in and move out date. Can be 12 months , 6 months. I want in current month how many apartments are coming under occupied category?

[@Syedhussainipage]

Hello, You may have to use these tricks with a combination of conditional functions such as "if". I'll be discussing these very soon in my upcoming videos. Best Regards, Syed H

[@khurrammansoor9805]

Absolutely perfect Nice teaching

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@credounamaca]

What if you want to work out how much time you worked on a shift? From supplementary hours to hours less than normal 9 hour shift?

[@richardrichard9522]

.

[@richardrichard9522]

Hgg

[@richardrichard9522]

Y

[@khushithakral4599]

What should we do to calculate time duration in minutes?

[@amritapritam2891]

Hii my excel is poor but i have to update sheet after putting value it's showing #value! How to correct it please say

[@kingjasko]

what if im trying to see the time from let's say 8pm to 9am? it would say 11 hours instead of 13, would i then need to use different date as well?

[@Syedhussainipage]

if the times are from different dates/days, then please enter the value with Date, only then you would get the right response. I tried and got 13 hours. Let me know if you still have issues, I will be more than happy to help.

[@kingjasko]

@@Syedhussainipage hey, I just added a cell with 24:00:00 and i now have 2 cells, 1 that shows from -12-12 hours and other one that adds 24 hours in case i get - I use that one, it's good enough, but yeah, I found out later date is the only good way :P

[@Syedhussainipage]

@@kingjasko Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@englishandmathstricks5242]

If there is 2 in or 2 out time then what will be formula

[@maryellenbrooks2921]

What if I need the difference to be all minutes instead of hours and minutes?

[@Syedhussainipage]

Hey there, I have posted a step-by-step process to achieve this here: onlineknowledgeportal.com/2024/06/14/show-the-time-difference-in-excel-in-minutes-only/ Please let me know how it goes.

[@maryellenbrooks2921]

@@Syedhussainipage Thank you for your reply! When I apply the formula =(xx - xx) * 1440 to my time frame, it comes back with 00:00. My times are formulated to hh:mm. I work in food manufacturing and the operators are not calculating regrind the same way each time, as they should be, so I want to create an Excel calculator for them. They would input the time frame and get the correct minutes back that they would use to calculate the regrind. The shifts are 12hrs (0700-1900) and (1900 to 0700).

[@Syedhussainipage]

@@maryellenbrooks2921 Can you share a sample data with me so I can take a look. You can also book a time slot for a quick Zoom call so I can help you. You can use this link to book 15/30 minutes: meetings.hubspot.com/syed57

[@maryellenbrooks2921]

@@Syedhussainipage I did not get a notification that you had replied, so thank you for waiting for me. I want to calculate the minutes between press start to time product was called good. i.e..operators would enter the press start 07:22 to good product 08:01. When I use your formula (08:01-07:22)*1440 it returns an answer of 0:00. It should say 0:39 min.

[@maryellenbrooks2921]

@@Syedhussainipage I figured it out! I am going to use the calculation that I found and just input the hour and the minutes in separate cells and then the formula I found works perfectly. Thank you for being available, and willing, to answer questions.

[@simpllife576]

Gret bro

[@garciarogerio6327]

Thank u.

[@Syedhussainipage]

Happy to help Garcia 🤠

[@pari-techfinance]

Same day & more than 1 day, PM to AM, this formula will not work. I tell u actual formula is =if(b>a),(b-a),1+(b-a) B is end time A is start time

[@nokpiadariusconstantino1333]

Тышудао

[@TERRYR27]

Hi could you please assist me in developing a formula where the start time is known and the duration of time is known if i start at 7am on a known date and the duration is 40 hours what day and time will the cycle finish?

[@Syedhussainipage]

Place the hours you would want to calculate in a different column/cell and add them to the known date and time. See this sheet for sample: drive.google.com/file/d/1Q4yKJLGeSBF17Uj_glyA6KbtyD6n1_wC/view?usp=sharing I hope you find it helpful. Let me know if you need any assistance.

[@222Amankr]

thanks

[@vaibhavchudasama9680]

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

[@Syedhussainipage]

You need to keep the results cell in the same format and use the Average function to draw the average of the time. Please see this link for reference: d.pr/i/XaXojT

[@Syedhussainipage]

I have added the GIF to my site to make it accessible for a longer time: onlineknowledgeportal.com/wp-content/uploads/2023/03/calculate-average-of-time.gif

[@epark9925]

Trying to calculate time spent when start time is Thursday 9/3/20 10:20 AM but end time isn’t til 9/7/20 2:30 pm. Do not work on Friday, Saturday, Sunday. Thank you

[@Syedhussainipage]

try this with the combination of NetWorkDays kzbin.info/www/bejne/rmjEe2SXf8iJq9E and let me know if you still need any assistance.

[@epark9925]

Thank you for your assistance. Now I have another problem I get a value error when start time or end time is blank cell. It also does not allow me to sum the total time spent with these value error. Additional help will be of big help.

[@resellingtrendz9845]

Hi i have one problem can u help me to solve

[@abdellatifboudelal167]

How to avoid blanks let's say my table has blanks? Please answer.

[@Syedhussainipage]

You can try nesting it under IF function in a way that if the cell is blank, do nothing else calculate the time difference in Excel. Let me know if this helps.

[@TSgDelRosarioTTSFW]

hi sir can you please, i manage to make a time computation table that will automatically compute add/subtract on the aircraft and engine time. however, the time computation table has only 3 spaces, then if those are fully filled out i can no longer continue the compitation and worst if i delete the entry on the time computation table it will delete the incurred result, can you help me fix it sir

[@Syedhussainipage]

Dear Leo, I will be more than happy to assist. You may drop a line on my Skype ID syhussaini or Hangouts on Google [e-mail] I am looking forward to hearing from you soon. Best Regards, Syed H

[@anglegend1970]

Help please i tried it but it states #value!

[@Syedhussainipage]

Please share sample data to look at.

[@anglegend1970]

@@Syedhussainipage Here are the date and time please help Cell 1 01.20.2020 7:14 Cell 2 01.20.2020 1:00 I have tried the simpliest way subtracting but still #value!

[@Syedhussainipage]

@@anglegend1970 it is not a valid date format in Excel since dot separators are invalid. If it is not a date, then it's a simple text to excel and hence the #value! error. Try SUBSTITUTE(Cell reference where the Date and Time are mentioned, ".", "/") and then do the difference of time. Let me know how it goes.

[@anumehasinha8363]

I am getting #Value! error while calculating for more than 1 day

[@Syedhussainipage]

Dear Anumeha, That should not happen unless we have a wrong argument passed. Let us get connected on Hangouts and I shall be able to assist you with your issues. I am available on Hangouts with [e-mail] Regards, Syed H | MyKnowledgePortal.com

[@muthusuthanradhakrishnan5542]

Hi

[@muthusuthanradhakrishnan5542]

I have one small doubt, assume 50 apartments having move in and move out date. Can be 12 months , 6 months. I want in current month how many apartments are coming under occupied category?

[@itzhakdavidi2775]

This tutorial is not correct. What if the worker is working a night shift and the end time is smaller than the start time?....

[@lectureryaseen9984]

not work

[@Syedhussainipage]

@@lectureryaseen9984 Let me know what didn’t work for you. If you can share a sample of the data you’re working with and your question, it’ll help me assist you better.

[@lectureryaseen9984]

@@Syedhussainipage many thanks sir for your interest the excel compute time but in hours and minutes however I need it to compute total time in minutes if you can help .... regards

[@tmvideos1978]

Can i have your email?

[@charlym9550]

Thank you very much