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
 
Search JabSto ::




Custom Search