Hours between two dates and time

Question

Is there a single formula solution to calculating the number of hours and minutes elapsed between two dates and times? E.g.


03/01/2020 17:18	09/01/2020 12:37

The time elapsed is 235 hours and 19 mins but is there an Excel formula to obtain this from the two values given?

riny_van_eekelen · Answer

Foxlute&nbsp;139 hours and 19 minutes, that is!&nbsp;Just enter a formula =&lt;End date - Start date&gt; (e.g.=B1-A1) and format as&nbsp;[h]:mm.&nbsp;&nbsp;

foxlute · Answer

I should have added that the dates are in UK format ddmmyyy

abiola1 · Answer

Kindly see the attached caption

riny_van_eekelen · Answer

Abiola1&nbsp;139 hrs and 19 min. Not 184 hours.

Forum Discussion

Hours between two dates and time

4 Replies

Resources