» Converting a Decimal Value to a Time Value
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Converting the decimal values in column A to correctly formatted time values.
Solution:
Divide each number by 24 as follows:
=A2/24
Format your result cells as custom "[hh]:mm".
Book Store:
Recommended Books:
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Positioning: The Battle for Your Mind
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- The Guide to Understanding Financial Statements
- Special Edition Using Microsoft Office XP
- Windows XP for Dummies
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
