Join Dennis Taylor for an in-depth discussion in this video Calculating time differences within and across days, part of Excel 2007: Working with Dates and Times.
Calculating time differences in Excel is very similar to calculating date differences.…And it's generally straightforward, as long as the starting and ending times are…within the same day.…But we want to talk about some more difficult situations, as well as the…straightforward situation, for example, that we are seeing in column C.…The starting and ending times in this example are all within the same day.…We simply want to know how much time has elapsed between the two times.…Equal the ending time minus the earlier time.…
And we see our answers here.…Just double-click to copy this down the column.…How much time has elapsed between those two times of day?…If this happens to be, and we can see by the examples this wouldn't represent…working time, but let's suppose we had a situation where you arrived in the…office at 8:41 in the morning.…You might type it this way, just as 8:41.…And if you hadn't formatted that, you might even put some strange things there.…
And you left the office on this given day at 5:03 PM. You might type it this way.…
- 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
1. Excel's Date/Time System
2. Creating Date/Time Entries
3. Date/Time Formatting
4. Excel's 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.