You can use the TIME function to add any number of hours, minutes, or seconds to a time. For example, assume that cell A1 contains a time. The following formula adds 2 hours and 30 minutes to that time and displays the result:

=A1+TIME(2,30,0)

You can use the TIME function to fill a range of cells with incremental times. Figure 16-9 shows a worksheet with a series of times in 10-minute increments. Cell A1 contains a time that was entered directly. Cell A2 contains the following formula, which copied down the column:

=A1+TIME(0,10,0)

FIGURE 16-9
Using a formula to create a series of incremental times.

• Track Your Money with Excel Many people utilize the software program known as Excel to set up their budget as well as to manage it....
• Is your time worth $2/hour or is it priceless? There are a number of different ways to value your time in order to determine whether to go the extra...
• Text Messaging is the Biggest Scam of the 21st Century Readers: The following post is lengthy to say the least.  The point of the post is obvious, what I do...
• Money Saving Tips: 75 Ways to Survive Recession Regardless of how economists refer to this economy, recession or no recession, people are hurting, financially. Unemployment, flat wages and...
• BlackBerry Curve Review I know this phone has been out for awhile, but I still want to review it since this is still...