Sometimes, you may want to work with time values that don’t represent an actual time of day. For example, you may want to create a list of the finish times for a race or record the time you spend jogging each day.

Such times don’t represent a time of day. Rather, a value represents the time for an event (in hours, minutes, and seconds). The time to complete a test, for example, may be 35 minutes and 45 seconds. You can enter that value into a cell as:

00:35:45

Excel interprets such an entry as 12:35:45 AM, which works fine. (Just make sure that you format the cell so that it appears as you like.) When you enter such times that do not have an hour component, you must include at least one zero for the hour. If you omit a leading zero for a missing hour, Excel interprets your entry as 35 hours and 45 minutes.

Figure 16-10 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)

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

FIGURE 16-10
This worksheet uses times not associated with a time of day.

• Callaway Tour ix Golf Balls (12-Pack) User Reviews Send this to a friend Callaway Tour ix Golf Balls (12-Pack) Manufacturer: Callaway Golf Customer Rating: List Price:...
• Weight Tracking (Last Attempt) Total Weight Lost: 58lbs Here is my weight tracking page... It will evolve as I get more accustomed to my...
• 8 Best Free Android Apps for Photo Editing [/caption] Android cameras just keep getting better. They’ve got great movie-making capabilities, killer flashes, and the megapixels are on the...
• Fierce struggle Champions Ticket Zone Fierce struggle Tickets Champions Zone - bola.okezone.com HTS Reserved "/> SED -> Palermo is now a team that seidkit the...
• 40 Critical Nights of Winter From Joint Base: From Thanksgiving eve through the end of the New Years Day-weekend there will be 40 nights of...