Learn about all the different ways Excel records and stores time. For instance, see how time is stored as a portion of a day; 6:00 AM is stored as .25, and 6:00 PM is stored as .75.
- [Narrator] Excel also has the capability…of handling information based on time of day…and time elapsed.…In this worksheet called times,…we see a list of data in columns A, B, and C,…based on an incident number,…perhaps this is a computer system, a networking system.…We've had some start times, end times,…possible these might read down time,…re-start time, that sort of thing.…Eventually we will want to calculate…the amount of time elapsed.…Although these do suggest hours and minutes,…we also possibly could be counting seconds in here as well…and eventually we will calculate the difference here.…
Notice how the times are entered.…They do contain a colon.…The data in columns F, G, and H…represent sales, certain number of units,…and a certain time of day.…Eventually we might want to analyze these sales,…based on the busiest times of day,…we can certainly do that,…and unlike dates, we have a different way of using time.…Sometimes we're calculating actual duration or length…and we might want to calculate the total here or an average.…
- 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.