See how easy it is to create standard date and time formats using a slash (/) or dash (-) to separate month, day, and year, and a semicolon to separate hours and minutes.
- [Instructor] In this worksheet…called Standard Date Time Formats,…this is in workbook chapter three,…in column B, we see the way the dates are displayed here…is probably the most common way,…at least within the United States.…Same thing in column E.…Now, there will be times when you don't need…to have the dates, or you don't want the dates…being displayed this way.…There are numerous options.…Sometimes, if the date is all within a year,…as it is in column E,…maybe you don't need to display the year.…And generally, the quickest way…to get to the formats that are available,…the alternate formats, is first select the data.…
And if it's in a column,…typically you can select the entire column.…If there's no other data other than dates here.…And you can quickly get into Format Cells…by pressing control one, it's really one of Excel's…best shortcuts, control one, Format Cells.…If you're not already at the number tab,…you'll need to click that.…And then, within the category called Date,…you'll see numerous options here.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- How Excel records and stores dates
- Using standard date/time entries and acceptable alternatives
- Formatting dates and times
- Creating standard date/time formats
- Working with dates and times in functions
- Calculating with dates and times
- Using dates/times with Excel commands
Skill Level Intermediate
1. Understanding the Excel Date/Time System
2. Creating Date/Time Entries
3. Formatting Dates and Times
4. Working with Dates and Times in Functions
5. Calculating with Dates and Times
6. Using Dates/Times with Excel Commands
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.