» Calculating Military Time Intervals
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Finding the interval between pairs of times when they are formatted in military style ("hhmm").
Solution 1:
Use the TEXT function as shown in the following formula:
=(TEXT(B2,"00\:00")-TEXT(A2,"00\:00"))*24
Solution 2:
Use the DOLLARDE function as shown in the following formula:
=DOLLARDE(B2/100,60)-DOLLARDE(A2/100,60)
Book Store:
Recommended Books:
- Learn MS Excel 2002 VBA/XML Programming
- Special Edition Using Microsoft Access 2002
- The Fall of Advertising and the Rise of PR
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Absolute Beginner's Guide to Microsoft Excel 2002
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
No comments have been submitted.
