Suppose you’re working in Excel and need to record the price of a certain stock
every 15 minutes as it is traded over a period of five hours. Rather than manually
typing in the time for each recording, you can use a formula to quickly and
automatically fill in the time increments for you. Follow these steps to enter
15-minute time increments in the range B1:B20:
the selection and select Format Cells.
Time and select 1:30 PM and click OK.
B1 and enter 10:00 AM.
- Select B2:B20 and enter =B1+Time(0,15,0)
Excel fills the range with 15-minute time increments. You
can now enter the data in the corresponding cell range in column C.
Miss a tip?
Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.
Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
Subscribe to the Developer Insider Newsletter
From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays