Working with Dates and Times
by Lisa A. Bucki, Gavin Powell, Michael R. Irwin, Peter G. Aitken, Michael R. Groh,
Office 2007 Bible
- Copyright
- About the Authors
- Credits
- Acknowledgments
- Introduction
- Common Office Features
- Creating Documents with Word
- Making the Numbers Work with Excel
- Persuading and Informing with PowerPoint
- A First Look at PowerPoint 2007
- Creating a Presentation, Slides, and Text
- Working with Layouts, Themes, and Masters
- Working with Tables and Charts
- Creating a New Table
- Moving Around in a Table
- Selecting Rows, Columns, and Cells
- Editing a Table’s Structure
- Applying Table Styles
- Formatting Table Cells
- Understanding Charts
- Starting a New Chart
- Working with Chart Data
- Chart Types and Chart Layout Presets
- Working with Labels
- Controlling the Axes
- Formatting a Chart
- Rotating a 3-D Chart
- Summary
- Using SmartArt Diagrams, Clip Art, and Pictures
- Understanding SmartArt Types and Their Uses
- Inserting a Diagram
- Editing SmartArt Text
- Modifying SmartArt Structure
- Modifying a Hierarchy Diagram Structure
- Formatting a Diagram
- Choosing Appropriate Clip Art
- About the Clip Organizer
- Inserting Clip Art on a Slide
- Clip Art Search Methods
- Working with Clip Art Collections
- Understanding Raster Graphics
- Importing Image Files into PowerPoint
- Sizing and Cropping Photos
- Compressing Images
- Summary
- Building Animation Effects, Transitions, and Support Materials
- Delivering a Live Presentation
- Organizing Messages, Contacts, and Time with Outlook
- Fundamentals of E-Mail
- Setting Up Your E-Mail Accounts
- Modifying Account Settings
- Using Outlook Profiles
- Composing and Sending Messages
- Reading and Replying to Messages
- Understanding the Inbox Display
- Understanding Files and Folders
- Outlook Data Files
- Working with Outlook Folders
- Deleting Items and Using the Deleted Items Folder
- Setting Options for an Individual E-Mail Message
- Setting Global E-Mail Options
- Summary
- Processing and Securing E-Mail
- Understanding Junk E-Mail Filtering
- Setting Junk E-Mail Options
- Blocking and Allowing Specific Addresses
- Understanding E-Mail Rule Basics
- Creating a New Rule
- Some Rule Examples
- Managing Rules
- Protecting Against Viruses
- Dealing with Attachments
- Macro Security
- Using Certificates and Digital Signatures
- HTML Message Dangers
- Summary
- Working with Contacts
- Working with Appointments and Tasks
- Fundamentals of E-Mail
- Designing Publications with Publisher
- Tracking Detailed Data with Access
- An Introduction to Database Development
- Creating Access Tables
- Getting Started with Access 2007
- Creating a Database
- The Access 2007 Environment
- Creating a New Table
- Creating tblContacts
- Setting the Primary Key
- Printing a Table Design
- Saving the Completed Table
- Manipulating Tables in a Database Window
- Adding Records to a Database Table
- Navigating Records in a Datasheet
- Changing Values in a Datasheet
- Summary
- Creating and Entering Data with Basic Access Forms
- Selecting Data with Queries
- Understanding Queries
- Creating a Query
- Selecting Fields
- Displaying the Recordset
- Working with Fields
- Changing the Sort Order
- Displaying Only Selected Records
- Printing a Query’s Recordset
- Saving a Query
- Adding More Than One Table to a Query
- Working with the Table/Query Pane
- Adding Fields from More Than One Table
- Understanding Multi-Table Query Limitations
- Summary
- Presenting Data with Access Reports
- Gathering Information
- Sharing and Collaboration
Chapter 16. Working with Dates and Times
In This Chapter |
|
Beginners often find that working with dates and times in Excel can be frustrating. To work with dates and times, you need a good understanding of how Excel handles time-based information. This chapter provides the information you need to create powerful formulas that manipulate dates and times.
Note
The dates in this chapter correspond to the U.S. English date format: month/day/year. For example, the date 3/1/1952 refers to March 1, 1952, not January 3, 1952. I realize that this setup may seem illogical, but that’s the way Americans have been trained. I trust that the non-American readers of this book can make the adjustment.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.