I need a spreadsheet column showing time in 30 sec. intervals

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

How do you develop a spreadsheet showing a column with 30 second intervals
over a day without having to enter each time individually?
 
One way would include the following
Format the column to time, maybe in the 00:00:00 format
Enter your first time as 00:00:00,second as 00:00:30 and thrid as 00:01:00
select these three cells, and using teh fill handle, fill the entire column
to your desired end time.

hth
 
Try this:

A1: 00:00:00

From the Excel Main Menu:
<edit><fill><series>
Check: Columns
Step value: 00:00:30
Stop value: 1
Click [OK]

If necessary, format the column
as an appropriate Time format.

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel MS Excel - MS Office 2010 0
Conditional formatting in Excel 2010 2
Inserting Multiple Rows into Spreadsheet 1
Days360() is only approximate 3
How do I calculate spreadsheet at five minute intervals 2
Convert Text in cell to hh:mm:ss 12
Trailing 30 days sum calculation with excel 1
vb code question 8

Back
Top