Millisecond Date Filling

[C_Rules]

Hi All if I have a date range expressed as yyyy-mm-dd-hh.mm.ss.000 and I want to increase the value by one millisecond for each new row and then have the time reset back to 0 for each new day For example:
2024-01-02-00.00.00.000
2024-01-02-00.00.00.000
2024-01-02-00.00.00.000
2024-01-02-00.00.00.000
2024-01-03-00.00.00.000
2024-01-03-00.00.00.000
2024-01-03-00.00.00.000

I need a formula to change those dates in a new column to be

2024-01-02-00.00.00.000
2024-01-02-00.00.00.001
2024-01-02-00.00.00.002
2024-01-02-00.00.00.003
2024-01-03-00.00.00.000
2024-01-03-00.00.00.001
2024-01-03-00.00.00.002

How can i accomplish this?

 

[Peter_SSs]

Hmm, are we getting any closer?

C_Rules.xlsm
	A	B
1
2	20240102	2024-01-02-00.00.00.000000
3	20240102	2024-01-02-00.00.00.000001
4	20240102	2024-01-02-00.00.00.000002
5	20240102	2024-01-02-00.00.00.000003
6	20240103	2024-01-03-00.00.00.000000
7	20240103	2024-01-03-00.00.00.000001
8	20240103	2024-01-03-00.00.00.000002
C_Rules (5)

Cell Formulas
Range	Formula
B2:B8	B2	=TEXT(A2,"0000-00-00")&"-00.00.00."&TEXT(COUNTIF($A$2:A2,A2)-1,"000000")

 

[kvsrinivasamurthy]

This is what I am getting.

2025-02-01	2025-02-01-00.00.00.000000
2025-02-01	2025-02-01-00.00.00.000001
2025-02-01	2025-02-01-00.00.00.000002
2025-02-02	2025-02-02-00.00.00.000000
2025-02-02	2025-02-02-00.00.00.000001
2025-02-02	2025-02-02-00.00.00.000002
2025-02-02	2025-02-02-00.00.00.000003

 

[C_Rules]

Hmm, are we getting any closer?

C_Rules.xlsm
	A	B
1
2	20240102	2024-01-02-00.00.00.000000
3	20240102	2024-01-02-00.00.00.000001
4	20240102	2024-01-02-00.00.00.000002
5	20240102	2024-01-02-00.00.00.000003
6	20240103	2024-01-03-00.00.00.000000
7	20240103	2024-01-03-00.00.00.000001
8	20240103	2024-01-03-00.00.00.000002
C_Rules (5)

Cell Formulas
Range	Formula
B2:B8	B2	=TEXT(A2,"0000-00-00")&"-00.00.00."&TEXT(COUNTIF($A$2:A2,A2)-1,"000000")

This is exactly what I needed, thank you so much.

Also, thank you to all who chimed in with possible solutions.

 

[Peter_SSs]

This is exactly what I needed, thank you so much.

You're welcome. Glad we got there in the end.

This is what I am getting.

Wrong initial data - again refer to post #2.
(Also still no action on this ..)

Why not update your profile so we know your version(s)/platform(s)?