Tip Printed from ExcelTip.com
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