Microsoft Office Tutorials and References

In Depth Information

**Chapter 13: Keeping Well-Timed Functions**

Chapter 13

Keeping Well-Timed Functions

In This Chapter

▶
Handling time

▶
Formatting time values

▶
Working with hours, minutes, and seconds

▶
Getting the current time

▶
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 specific times if needed.

Excel uses the decimal side of the serial number to represent time as a

fraction of the 24-hour day. Thus, 12 p.m. (noon) is 0.5, and 6 p.m. is 0.75. Table

13-1 shows some more examples and reveals how dates and time information

are combined in a single serial number.