count every ten seconds

Hello im trying to sumup every ten seconds

i have cloumn (11) which contains date and time and im trynig to write in cloumn (12) which ten seconds are they

such as the first ten seconds are number one

the second ten seconds are number two

which code do i have to write ?

[Image Analyst]

Here's another chance to read the posting guidelines:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

So we can answer once you've attached your data.

[grace khashman]

i mean :sort every ten seconds in a new cloumn

[Image Analyst]

OK but once again, youi forgot to attach your data. You may get no answers at all until that happens.

[grace khashman]

here's my data im trying to sort every ten seconds in cloumn 10 into new one in cloumn 11

in other words im trying to use a fore loop that can sort the first ten seconds into a new variable that will apear in cloumn 11 as 1

the second ten seconds is number 2 and like that..... til 71658.

Answer 1

[Walter Roberson]

Hello im trying to sumup every ten seconds

Convert to timetable() objects and use retime()