aries1988 : excel   10

Calculate the difference between two times - Excel
A

B

Start time

End time

6/9/2007 10:35 AM

6/9/2007 3:30 PM

Formula

Description (Result)

=INT((B2-A2)*24)

Total hours between two times (4)

=(B2-A2)*1440

Total minutes between two times (295)

=(B2-A2)*86400

Total seconds between two times (17700)

=HOUR(B2-A2)

The difference in the hours unit between two times. This value cannot exceed 24 (4).

=MINUTE(B2-A2)

The difference in the minutes unit between two times. This value cannot exceed 60 (55).

=SECOND(B2-A2)

The difference in the seconds unit between two times. This value cannot exceed 60 (0).
excel  howto  numbers  date
may 2017 by aries1988
Excel 到底有多厉害？

excel  job  tips
july 2016 by aries1988
Comment faire pour créer des liens hypertexte absolus et relatifs dans des documents Word 2003 et Word 2007
Comment faire pour utiliser des liens hypertexte absolus au lieu de liens hypertexte relatifs
office  data  excel
april 2016 by aries1988

Copy this bookmark:

to read