|
» Negative times in Microsoft Excel
VBA macro tip contributed by
Erlandsen
Data Consulting offering Microsoft Excel Application development,
template customization, support and training solutions
|
|
 | |
CATEGORY: Excel Time |
VERSIONS: All Microsoft Excel Versions |
|
If you calculate with time values, you will soon discover that Excel is not fond of negative time values. You can bypass this limitation by using the option 1904 date system. You find this setting by using the menu item Tools, Options..., Calculation. Select this option before you enter any dates or time values in your workbook, if not you'll have to edit all the existing date- and time values. If you want to enter a negative time value you have to do it like this: -"10:15" Or like this: = -10.25/24 If you prefer not to use the option 1904 date system in your workbook, you can use the IF-function to separate the positive and negative time values. This gives you the opportunity to have one column for the positive time values and another column for the negative time values. |
|
RATING:
4.18
VIEWS: 30635 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- The Intelligent Investor: The Classic Bestseller on Value Investing
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
