recentpopularlog in

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 到底有多厉害?
微软(Microsoft) 软件 Microsoft Excel Mathematica 到底有多厉害? - Wolfram Mathematica MATLAB 到底有多厉害? - 编程 • (在 做投行、行研、咨询等金融岗位,有没有什么好用的找数据技巧呢? - 何明科的回答…
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