Calculate time difference in Excel #shorts

How to calculate the difference between two times in Excel. The same formula can be used to find out hours worked.

🍐Join my online course on Excel Tables

🍓Download my free eBook on Excel Macros

🍇Check these Books on Excel

🍉Read my articles on Excel

🍏Playlist for Shorts on Excel

#excelshorts #exceltip #exceltrick

[LetThere-BeChaos]

I swear everytime I watch one this guys videos its like wizardry or somethin like look at that

[goldenguras]

The easiest formula. Simple is beautiful. Just witnessed it.

[kashmirishawlmakingtutoria]

In cell c3, b3 end start- start time. From 8am to 5:30pm is 9:30 hours. But in ur cell it is 9: 50 hours. Can u sir reply it how 20 minutes are extra there. Please sir reply my confusion...

[colourfulrainbow]

Excellent, very easy to understand, thank you 👌👌👌👌

[Mr.Peace....]

What a base you have in your voice bro . 👌

[rufaidabappu]

Can you make a video on period of work ? Like one date to how many months or years he is working with one company to be calculated

[Virgus-vjxr]

thank you omg ur the only one who knew 😲😲😲😲😲🙂🙂🙂

[tghostgaming]

You deserve a like share and a comment 😊

[nandishnandish]

How was the data entry work in jobs or company demo video please

[musaddiqueansari]

How to get avg value of share price bought at different rates on multiple lots

[satishmandlik]

Your answer is wrong.
Correct answer is 43 hours 50 minutes
Aata hai.
Please correct your formula.
Minutes is not correct in your excel sheet.

[Mishrarajesh]

This is wrong pettern to calculate the time difference.

Can you please explain the hr and mint of total worked hrs as your total is 43: 82 Hours

What is 82

[ibrahim]

Hello is there a way of know how many hours an employee has working during the PM

[mass]

If I use your format it comes answer is #value! How to change this ?

[RIgRigMolu]

Will it work the same way if start time is 10 PM and end time is 6 am next day

[sanjidajui]

Why there it shows"value" in total time?

[stevenlawrence]

This is incorrect.

This is the correct formula and steps
=END TIME - START TIME
The answer will show a time like yours did in the video. Instead of formatting the outcome to a “Number” format (which changes it to a 100 system rather than a 60 system such as time) choose the “Time” format and select the Time format that looks like “13:30”. This will generate the correct answer AND remain in the 60 system format so there will be no need to reformat the totals to a 60 system from a 100 system like you showed in the video.

[TahirAcademyOfficial]

Great work...
I am also teaching excel on my channel...

[digitaldescent]

Input_data : "2:10:15"
I want Output_data : 2 10 15 && 2:10:15
Can you tell me how can do that ??

[chavaliyamini]

I think correct time is 9.30....how to come 9.50...