Excel Formulas Time And Date Calculations

Date Functions Start Date End Date

9/10/2000 10/20/2002

Number of months between above dates: 25.00

=(YEAR(C5)-YEAR(C4))*12 + MONTH(C5)-MONTH

Number of days between above dates:

2/8/1902

=C5-C4

Number of years between above dates:

2.00

=YEAR(C5)-YEAR(C4)

Elapsed Time 9:15

=C8-B18

Time Functions Summing Time Start Time 8:15 AM

End Time 5:30 PM

Accumulating Time Over 24 Hours

Total (in decimal): Total ([h]:mm:ss):

9:00 12:30 16:05 22:00 59.58 =SUM(C21:C24)*24 59:35:00 =SUM(C21:C24)

Converting Time in h:mm Format to Decimal Format 17.83 17:50 =(C29-INT(C29))*24 Converting Time in Decimal Format to h:mm Format 4:30:00 4.5 =TIME(TRUNC(C32),ROUND((C32-TRUNC(C32))*60,),0)

To convert time LESS THAN 24 HRS from h:mm format to a decimal format Monday 9:00 Tuesday 8:40

0:30 0:30

18:15 17:30

8:45 8:20 17:05 =SUM(F37:F38) 17.08 =(F39-INT(F39))*24

C4))*12 + MONTH(C5)-MONTH(C4)

hrs mins hrs decimal