Count steps/minute based on a date value

[fogarasia]

Hi All!
I have the attached Table. I want to count the steps/minute. So based on the formula column D is counting until F's minute change. So at least I would like to do that. As you see the counting is restarting at line 7 instead of line 14. What could be wrong? Changing one by one from the date column is not possible as I have hundreds of thousands of data.

Statisztika feb02-09.xlsx
	C	D	E
1	TimeString	Colonna1	Colonna2
2	31/01/2023 13:09:41
3	31/01/2023 13:09:42	1
4	31/01/2023 13:09:43	2
5	31/01/2023 13:09:44	3
6	31/01/2023 13:09:46	4	4
7	31/01/2023 13:09:46	1
8	31/01/2023 13:09:48	2
9	31/01/2023 13:09:49	3
10	31/01/2023 13:09:50	4
11	31/01/2023 13:09:51	5
12	31/01/2023 13:09:52	6
13	31/01/2023 13:09:53	7
14	31/01/2023 13:15:10	8
15	31/01/2023 13:15:11	9
16	31/01/2023 13:15:12	10
17	31/01/2023 13:15:13	11	11
Munka4

Cell Formulas
Range	Formula
E2:E17	E2	=IF(D2>D3,D2,"")
D3:D17	D3	=IF(C3=C2,1,D2+1)

 

[fogarasia]

Sorry, I found it!

Statisztika feb02-09.xlsx
	F
3	1
feb02-09_bal stat

Cell Formulas
Range	Formula
F3	F3	=IF(MINUTE(B3)<>MINUTE(B2),1,F2+1)

 

[Fluff]

How about

=IF(MINUTE(C3)=MINUTE(C2),D2+1,1)

 

[fogarasia]

Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.