Microsoft Office Tutorials and References

In Depth Information

**Summary**

Figure 16.9 shows an example of a worksheet set up to keep track of a personâ€™s jogging

activity. Column A contains simple dates. Column B contains the distance in miles. Column

C contains the time it took to run the distance. Column D contains formulas to calculate

the speed in miles per hour. For example, the formula in cell D2 is:

=B2/(C2*24)

FIGURE 16.9

This worksheet uses times not associated with a time of day.

Column E contains formulas to calculate the pace, in minutes per mile. For example, the

formula in cell E2 is:

=(C2*60*24)/B2

Columns F and G contain formulas that calculate the year-to-date distance (using column B)

and the cumulative time (using column C). The cells in column G are formatted using the

following number format (which permits time displays that exceed 24 hours):

[hh]:mm:ss

Summary

In this chapter, you learn how Excel treats dates and times as serial numbers. You can use

dates and times in formulas, as long as you understand how serial numbers work. This

chapter also introduced you to some Excel functions that work with dates and times, and