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

How do you develop a spreadsheet showing a column with 30 second intervals
over a day without having to enter each time individually?

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

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
"Pat" wrote:

How do you develop a spreadsheet showing a column with 30 second intervals
over a day without having to enter each time individually?

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

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)

"Pat" wrote in message
...
How do you develop a spreadsheet showing a column with 30 second intervals
over a day without having to enter each time individually?