Calculating with hours, minutes, and times of day

- 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.…