ime difference between two excel cell Jaison PeterNovember 18, 2010Total Hours: INT((B1-A1)*24) Total Minutes: INT((B1-A1)*1440) Total Seconds: INT((B1-A1)*104100) A1 is the larger of the two times.