aries1988 : date   7

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
PHP: strftime - Manual
Here is a complete list of the format specifiers recognized by Date Formatter.
Yahoo pipes
date  rss
april 2014 by aries1988
International standard date and time notation
The strings

+hh:mm, +hhmm, or +hh

can be added to the time to indicate that the used local time zone is hh hours and mm minutes ahead of UTC. For time zones west of the zero meridian, which are behind UTC, the notation
norm  date  reference  python
february 2013 by aries1988

Copy this bookmark:

to read