How do you create columns that increase by milliseconds?

[trietta]

I need to create columns that increase in intervals of 33 milliseconds. So, the first column is 00:00:00. 2nd column is 00:00:33. 3rd column is 00:00:66. And so on until I reach 2 minutes.

Is there an easy way to do this in Excel?

 

[macattackpro]

Easy? Potentially:

33 milliseconds in decimal form is 0.033 of a second.

A second in terms of a portion of a day is (1 Second/1 Minute/1 Hour/1 Day) or =1/60/60/24

So, 33 Milliseconds is

=0.033/60/60/24

Add that to your time and it'll increase by 33 milliseconds.

 

[trietta]

Thanks! I tried that, but was unable to get it to display in the format I need and copy across the columns...

 

[Jonmo1]

in A6, I just manually typed the first value 0
Then in B6
=A6+"0:00:00.33"
And filled right.

Format the cells as hh:mm:ss.00

Book1
	A	B	C	D	E
6	00:00:00.00	00:00:00.33	00:00:00.66	00:00:00.99	00:00:01.32
Sheet1

Cell Formulas
Range	Formula
B6	=A6+"0:00:00.33"
C6	=B6+"0:00:00.33"
D6	=C6+"0:00:00.33"
E6	=D6+"0:00:00.33"

 

[trietta]

This looks promising.. But what am I doing wrong? I try to format the cells as hh:mm:ss:00 and I get an error message saying that Excel cannot use the number format I typed.

in A6, I just manually typed the first value 0
Then in B6
=A6+"0:00:00.33"
And filled right.

Format the cells as hh:mm:ss.00

	A	B	C	D	E
6	00:00:00.00	00:00:00.33	00:00:00.66	00:00:00.99	00:00:01.32

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B6 =A6+"0:00:00.33" C6 =B6+"0:00:00.33" D6 =C6+"0:00:00.33" E6 =D6+"0:00:00.33" <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[Jonmo1]

Check the format I suggested VERY Carefully.

 

[trietta]

Ah! Got it! Thanks!

 

[Jonmo1]

You're welcome.