Calculate time difference in excel between 2 times

Calculate the time difference between 2 given times in Excel, using the =TEXT formula.

Very useful to calculate time taken by a customer service executive to resolve an issue over phone, or time taken by a runner to complete his/her race.

Also add meaningful analysis in your data using the nested IF function and Conditional formatting.

More videos to learn Excel from

SUBSCRIBE to Excel Rush's YouTube channel!

Blog

[morenikejibankole]

Hi Rushab, thank you so much for this video. Yeah I know its old but trust me it is a life saver for me right now. How I wish I can get a video on converting elapsed time I will be so glad. (the elapsed time was exported from a CS Software as CSV into excel and converting the elapsed time has been difficult. I have tried the 84600 function but is it not giving me the exact time for each ticket. I will be glad if you can assist. Thank you advance

[tariqrasheed]

Great video! what if the scenario is between 2 dates like it happens in night shifts. Start time is 23:00 and end time is 02:00. How do we calculate number of hours then?

[paulsimpson]

Hello, why is it, I copy your input but when times are added, they all read 00.00.00 pls help

[parshurambhave]

The same thing can be done without the helper column using the following formula :
=if(Text(C4-B4, "hh:mm:ss")>"00:05:00", "corssed", "intime")

[leocadiomachado]

thank you so much, very easy to follow.

[souvikghosh]

how to get time difference in xl from today () and any other time in any other cell ? The time must be in year format.

[zhenbushuai]

Hi I try ur formula but can't for me I don't know which did wrong

[ISTARI]

What formula can I use if say I started something at 6pm today and it ended 3am next day. I tried =(TEXTD6-C6, "HH:MM")) It showed #VALUE!

[ShamalKaden]

What if my target is 1 Hour, How does it work, How do I specify second IF logic, including Minute & Time grater that 0 return as crossed?

[Mr_]

Why doesn't this work on my machine?

[propwebrealtyservices]

Thank You for this, it helped to solve a major issue.

[mrkenzo]

may I know how to calculate the time difference, in terms of "percentage"?
I mean something like 1.5 hour, 2.5 hour, etc..

[manojprabhakaran]

Excellent to understand - Kindly help us with one more concept, We have to find the deviation within the start and end window, for example,
Planned start date: 2019-04-02 18:30: 00, Planned end date:2019-04-02 19:00:00
Implementation start date : 2019-04-03 01:14:05 Implementation end date 2019-04-03 01:14:47
The technical guy was not done the activity within the scheduled window, in this, I need to find if any deviation I should get an error.
In implemenation colum, if the start date shows before the planned date or after the planned end date, I should find, please help,

[nammachannel.]

How to calculate time difference between 11:55 pm to 12:10 am

[HemapriyaAWS]

Thanks alot... How to do final sumup of all the difference??

[denisecodorniu]

Thank you!!! i will be referring back to this video multiple times haha

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

[suryavishwanath]

thank you soo much.. i was literally needing of this exact formula only...

[infochippvtltd]

Hello
In My Excel, I have two columns
I have shared the data of my columns.
Column1: 2023-07-24T06:44:03.000Z
Column2: 2023-07-24T06:44:16.000Z

How do I get these two columns different in "Seconds" Only?

[Subhabrata]

Thank you very much! It helped a lot!👍