Chapter 6. Dates and Times: Stay on time

image with no caption

Dates and times in Excel are hard.

Unless you understand how Excel represents them internally. All of us at one point or another have had to do calculations involving these types of figures, and this chapter will give you the keys to figuring out how many days, months, years, and even seconds there are between two dates. The simple truth is that dates and times are a really special case of the data types and formatting that you already know. Once you master a couple of basic concepts, you’ll be able to use Excel to manage scheduling flawlessly.

Do you have time to amp up your training for the Massachusetts Marathon?

You’re an avid runner who is ready to make the transition to an elite status, pursuing more prestigious, competitive, and difficult races. Specifically, you think you’re ready for the Massachusetts Marathon.

Or rather, you could be ready with the right training program. Elite running is all about scheduling your practices and races so that you’re at the right level of fitness at the right time. Luckily, you have a trainer friend who wants to help.

image with no caption

Get Head First Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.