Tips Calkulasi Number of Minute dalam Microsoft Excel 2000

Tips Calkulasi Number of Minute dalam Microsoft Excel 2000
------------------------------------------------------------------------

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

Screenshot // Calculate number of minutes between dates - time in Microsoft Excel