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.

• National Geographic's 411 on Family Eco-Vacations plus Waterfalls no one ever told you existed in Yosemite on Smart Green Travel on Green 960 AM San Francisco Find where waterfalls rarely visited in Yosemite are located and easy to walk too. And, I believe I've found the...
• 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....
• Satya Sai Baba Incense Collection - 25 Boxes, 21 Different - All the Satya Varieties At One Time User Reviews Send this to a friend Satya Sai Baba Incense Collection - 25 Boxes, 21 Different - All the...
• 500 More Useless Facts [/caption] Most American car horns honk in the key of F. The name Wendy was made up for the book...
• The Complete History of Cell Phones - From 2-Way to 4G [/caption] Part I: Wireless roots Like many of the great revolutions, it was born out of necessity. Owing more to...