Calculate between two times (2)

Using TEXT formula to calculate time. 

Use =TEXT(End time-Start time,"format to use") to calculate between two times. Simply replace the format to use with:

h = hour

mm = minutes

ss = seconds.

Example:

The result would be,

You can also personalize the formula.

This will return the result based on each preference.

Calculate between two times (1)

 How to calculate between two times? 

To get the time difference, just use End Time - Start time. In this case, it would be =B2-A2.

The answer should be 9:14:30, 9 hours 14 minutes and 30 seconds.

Or you can use HOUR, MINUTE and SECOND formula.

The result would depend on which formula that you choose.

How to calculate age using Microsoft Excel

 To calculate age using Microsoft Excel, just use the simple formula DATEDIF. Example would be =DATEDIF(date to compare, current date, "y")

For example, 

Here's the two dates to compare. In selected destination cell, type =DATEDIF(A2,B2,"y")

You'll get the specific age as the result.