» 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:
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Analyzing Markets, Products, and Marketing Plans
- How to Read A Financial Report
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
