Excel 2010 Dates & Times (Tech 102) - Couverture souple

Hill, Tim

Couverture souple

ISBN 10 : 1937842959 ISBN 13 : 9781937842956

Editeur : Questing Vole Press, 2011

Synopsis

The secret to working with dates and times is understanding how Excel stores and interprets these values. Though dates and times look like text values ("June 22, 2012" or "10:30 AM", for example), they're actually serial numbers. This handy guide teaches you how to do date arithmetic, use Excel's built-in date/time functions (including the undocumented DATEDIF function), and avoid pitfalls like the leap-year bug and negative times. You'll also find advanced clock and calendar tricks such as rounding times and calculating holidays.

• Understand date and time serial numbers.
• Control how Excel interprets and formats dates and times.
• Resolve problems with two-digit years and negative times.
• Work around Excel's leap-year bug.
• Generate series of dates and times.
• Convert imported text and numerical values to dates and times.
• Skip weekends and holidays in business and financial calculations.
• Find specific days of the month for holidays and paydays.
• Round times to the nearest hour, half-hour, minute, or any interval.
• Fully indexed and cross-referenced.

Contents
1. Date & Time Basics
2. Date & Time Functions
3. Date Tricks
4. Time Tricks

About the Author
Tim Hill is a statistician living in Boulder, Colorado. He holds degrees in mathematics and statistics from Stanford University and the University of Colorado. Tim has written self-teaching guides for Algebra, Trigonometry, Geometry, Precalculus, Advanced Precalculus, Permutations & Combinations, Mathematics of Money, and Excel Pivot Tables. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.

A propos du livre

Présentation de l'éditeur

The secret to working with dates and times is understanding how Excel stores and interprets these values. Though dates and times look like text values ("June 22, 2012" or "10:30 AM", for example), they're actually serial numbers. This handy guide teaches you how to do date arithmetic, use Excel's built-in date/time functions (including the undocumented DATEDIF function), and avoid pitfalls like the leap-year bug and negative times. You'll also find advanced clock and calendar tricks such as rounding times and calculating holidays.

• Understand date and time serial numbers.
• Control how Excel interprets and formats dates and times.
• Resolve problems with two-digit years and negative times.
• Work around Excel's leap-year bug.
• Generate series of dates and times.
• Convert imported text and numerical values to dates and times.
• Skip weekends and holidays in business and financial calculations.
• Find specific days of the month for holidays and paydays.
• Round times to the nearest hour, half-hour, minute, or any interval.
• Fully indexed and cross-referenced.

Contents
1. Date & Time Basics
2. Date & Time Functions
3. Date Tricks
4. Time Tricks

About the Author
Tim Hill is a statistician living in Boulder, Colorado. He holds degrees in mathematics and statistics from Stanford University and the University of Colorado. Tim has written self-teaching guides for Algebra, Trigonometry, Geometry, Precalculus, Advanced Precalculus, Permutations & Combinations, Mathematics of Money, and Excel Pivot Tables. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.

Détails de l'édition

• Éditeur: Questing Vole Press
• Date d'édition: 2011
• Langue: anglais
• ISBN 10: 1937842959
• ISBN 13: 9781937842956
• Reliure: Broché
• Nombre de pages: 54
• Coordonnées du fabricant: non disponible
• Personne responsable: non disponible