Since one day equals 1 and one day equals 24 hours time in Excel can represented as fractional values of 1 as shown in the table below. Use DATEDIF again with ym to find months. And when further you multiply it by 24 total number of hours in a day it converts that decimals into the number of hours and minutes.
Use DATEDIF to find the total years.
Hours End_DateEnd_Time- Start_DateStart_Time24. In the formula the y returns. Since one day equals 1 and one day equals 24 hours time in Excel can represented as fractional values of 1 as shown in the table below. Select the cell in which you want to insert the formula.