Calculate number of Minutes between Dates

Calculate number of minutes between dates - time in Microsoft Excel

Data in cell A1:B2

	A	B
1	End Date/Time	05/11/2003 15:33	<-- =NOW()
2	Start Date/Time	10/01/2002 9:33	<-- =NOW()-222.25

Formula in cell E2: =(B1-B2)*1440 ( 24 hours*60 minutes=1440 )

Format in cell E2: regular number format

Result: 320,040 minutes

Related Articles to Read