ExcelTip.com
ExcelTip.com
Account Icon Account Icon Account Icon
Google Exceltip.com
JOIN OUR NEWSLETTER
  and receive for joining:
Free eBook Learn More!
Free Excel ADD-IN
Free Weekly Excel Tip
4 e-books in cd-rom
F1 Formulas & Functions
F1 Formulas & Functions
F1 EXCEL
F1 eBook (Spanish)
F1 EXCEL
Financial Statements.xls
 

» 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

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

Calculate number of minutes between dates - time in Microsoft Excel
Rate this tip
12 34 5
  RATING: 3.54
  VIEWS: 125967

READER COMMENTS (view all comments)


No comments have been submitted.


REGISTERED USERS - Click here to post comments


GUESTS (Click here to register)
Name
Comment Title
Comments

Fish! A Remarkable Way to Boost Morale and Improve Results

Good to Great: Why Some Companies Make the Leap... and Others Don't

Writing Excel Macros with VBA, 2nd Edition

Getting to Yes: Negotiating Agreement Without Giving In

Marketing Planning for Services

Microsoft Word Version 2002 Step By Step (With CD-ROM)

RELATED MICROSOFT EXCEL TIPS


Convert PDF Files to Excel


Excel VBA books
Accounting books
Business Plans
MS Office books
Taxes books

VIEW ALL BOOKS