» Calculate number of minutes between dates - time in Microsoft Excel
CATEGORY - Excel Dates , Excel Time
VERSION - All Microsoft Excel Versions
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
Book Store:
Recommended Books:
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Financial Statement Analysis with S&P insert card
- The Intelligent Investor: The Classic Bestseller on Value Investing
No comments have been submitted.
