How many hours between two dates

Collectives on Stack Overflow. Learn more. Get hours difference between two dates in Moment Js Ask Question. Asked 7 years, 3 months ago. Active 1 month ago. Viewed k times. I'm able to get the difference between two dates using MomentJs as follows: moment end. How do I get the difference in hours between two Moments? Improve this question. Dani Dani 5, 2 2 gold badges 15 15 silver badges 19 19 bronze badges. Add a comment. Active Oldest Votes. Improve this answer. GregL GregL Shouldn't it be startTime.

The duration. Except it would be end. However, your second point is not correct. GregL I stand corrected jsfiddle. Try wrapping it with moment to convert it. Show 5 more comments. Naseer 3 3 silver badges 9 9 bronze badges. At least his code block showed all the variables that were in use unlike the accepted answer or the question.

If someone wants to down vote they, should down vote the question as it is an incomplete code block to start. Does that code block really need explanation?

If you use the custom format to display hours, the actual number stored by Excel is in days, so to convert to hours just multiply by 24 and make sure it is formatted as a number. You are commenting using your WordPress.

You are commenting using your Google account. You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. This site uses Akismet to reduce spam. Learn how your comment data is processed. Newton Excel Bach, not just an Excel Blog. An Excel blog for engineers and scientists, and an engineering and science blog for Excel users. Skip to content. Time in hours and minutes between two dates Posted on September 30, by dougaj4.

Select Custom, then h:mm. Time differences greater than 24 hours should now display correctly in hours and minutes see cell F8 below.

It is possible to use the same approach with the Text function Row 9 below. Note that the time difference now displays in hours and minutes, regardless of the cell format. Like this: Like Loading This entry was posted in Excel and tagged Excel , format times , greater than 24 hours , Text function , time difference. Deep Dive Into Cryptocurrency. ET Markets Conclave — Cryptocurrency.

Reshape Tomorrow Tomorrow is different. Let's reshape it today. Corning Gorilla Glass TougherTogether. ET India Inc. ET Engage. ET Secure IT. Web Stories. Morning Brief Podcast. Economy Agriculture.

Foreign Trade. Company Corporate Trends. Defence National International Industry. International UAE. Saudi Arabia. US Elections World News. Time Difference Calculator This calculator can be used to "add" or "subtract" two time values. Modify the values and click the calculate button to see result. Days this. Hours this. Minutes this. Seconds this. Add to or Subtract from a Date This calculator is used to add or subtract time days, hours, minutes, seconds from a chosen time and date.

AM PM. Time Duration Calculator Use this calculator option to find the difference of hours, minutes, and seconds between two particular time values.

Start Time Hours this. End Time Hours this. Start Time. End Time.