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

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?
 
J

JR Hester

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
 
R

Ron Coderre

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)
 
Top