Excel 2010 Bible

Part II: Working with Formulas and Functions

280

Figure 12.11 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 12.11

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

On the CD
You can also access the workbook shown in Figure 12.11 on the companion CD-ROM. The file is named
jogging log.xlsx.