Join Dennis Taylor for an in-depth discussion in this video Calculating with hours, minutes, and times of day, part of Excel Tips Weekly.
- Excel gives us tools,…not only for calculating differences between dates,…but also between times.…Typically, if we're measuring time differences,…we've got a starting time, an ending time,…and a simple formula here subtracting the two,…and we always want to be subtracting…the later time minus the earlier time,…= the later time - the earlier time,…we get an answer.…Now, as is often the case when you work with times,…you get funny results based on the format.…
The actual answer here is 5:49,…but the AM throws us a bit.…Very often, when you're working with times,…you'll need to go into Format Cells,…and you can get there quickly with Control + 1.…Time category, most of the time when you're making changes,…you'll either change to 13:30 or the 1:30 PM.…This adds the AM/PM indicator.…We don't want that here.…13:30 allows us to display times up to 24 hours,…so we see that.…
Double click, we see the calculations on the others.…If, somehow, we've got these backwards,…or, let's say, for example,…I'm going to change this one, I'll make it be PM.…
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- 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.