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

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]6[/TD]
[TD="align: right"]00:00:00.00[/TD]
[TD="align: right"]00:00:00.33[/TD]
[TD="align: right"]00:00:00.66[/TD]
[TD="align: right"]00:00:00.99[/TD]
[TD="align: right"]00:00:01.32[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B6[/TH]
[TD="align: left"]=A6+"0:00:00.33"[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C6[/TH]
[TD="align: left"]=B6+"0:00:00.33"[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D6[/TH]
[TD="align: left"]=C6+"0:00:00.33"[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E6[/TH]
[TD="align: left"]=D6+"0:00:00.33"[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Jonmo1]

Check the format I suggested VERY Carefully.

 

[trietta]

Ah! Got it! Thanks!

 

[Jonmo1]

You're welcome.