Microsoft Office Tutorials and References

In Depth Information

Figure 6-12:
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

You can access the workbook shown in Figure 6-12, jogging log.xlsx, at this book's

website.