Skip to Main Content
Excel Formulas and Functions For Dummies, 3rd Edition
book

Excel Formulas and Functions For Dummies, 3rd Edition

by Ken Bluttman
February 2013
Beginner content levelBeginner
408 pages
9h 10m
English
For Dummies
Content preview from Excel Formulas and Functions For Dummies, 3rd Edition

Chapter 13

Keeping Well-Timed Functions

In This Chapter

arrow Handling time

arrow Formatting time values

arrow Working with hours, minutes, and seconds

arrow Getting the current time

arrow Calculating elapsed time

Excel has a superb handful of functions for working with times and performing calculations on time values. You can analyze data to the hour, minute, or second. And Excel helps you get this done in a New York minute!

Understanding How Excel Handles Time

In the previous chapter, I explain how Excel uses a serial number system to work with dates. Well, guess what? The same system is used to work with time. The key difference is that, although dates are represented by the integer portion of a serial number, time is represented by the decimal portion.

What does this mean? Consider this: 41640. That is the serial number representation for January 1, 2014. Notice, though, that there is no indication of the time of day. The assumed time then is 12 a.m. (midnight), the start of the day. You can, however, represent ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Formulas & Functions For Dummies, 5th Edition

Excel Formulas & Functions For Dummies, 5th Edition

Ken Bluttman

Publisher Resources

ISBN: 9781118460856Purchase book