Join Dennis Taylor for an in-depth discussion in this video Calculating time differences within and across days, part of Working with Dates and Times in Excel 2010.
Calculating time differences like date differences is generally pretty…straightforward. Usually it's just subtracting two different cells.…But we also need to consider what happens if the information extends…over multiple days.…In the entries in Columns A and B here, these are all within the same day.…We want to know how much time has elapsed between the two entries.…Equal the later entry minus the earlier entry. There it is.…I am going to copy this down the column.…And we see in each case what's going on here.…
In the last example down here, these are within the same day.…Let's make a change here.…Suppose this has to do with working time.…You want to tabulate how long someone is at the office on a given day.…We'll change this entry here.…I'm just going to type in here, 8:10, Enter.…And this person is leaving the office, and I'm going to type this in as 5:27 P,…nine hours and 17 minutes.…Sometimes when we want to do those, we need to know how much of working time…was spent, and this person wasn't here for an hour for lunch.…
- Understanding how Excel records and stores dates and times
- Looking at standard date/time entry options and acceptable alternatives
- Using the TODAY and NOW functions
- Customizing date formats
- Exploring keyboard shortcuts
- Formatting time for hours over 24
- Calculating differences across dates and times
- Rounding calculations
- Working with holidays
- Validating with dates
- Converting formatted dates to usable data
Skill Level Intermediate
Excel 2010: Advanced Formatting Techniqueswith Dennis Taylor3h 2m Intermediate
1. Excel's Date/Time System
2. Creating Date/Time Entries
3. Date/Time Formatting
4. Date/Time Functions
5. Calculating with Dates and Times
6. Using Dates and 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.