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




Custom Search