Copy Alternate cells of a Column

Hi All,

I am trying to copy the alternate cells of a column.
I used the formula.
=INDEX(A:A,1+(2*ROW()-1))
=INDEX(A:A,1+(2*ROW()-2))

but it is not giving the expected results.

Here is the Example

Column A
11:53:35 PM
11:53:42 PM
12:18:43 AM
12:18:49 AM
12:41:20 AM
12:41:27 AM
01:07:01 AM
01:07:10 AM
01:31:38 AM
01:31:46 AM
01:37:33 AM
01:37:42 AM
01:38:25 AM
01:38:49 AM
01:38:51 AM
01:39:01 AM
01:39:01 AM
01:39:14 AM


I want to copy the alternate cells and find the difference

Column B Column C DIFF of C and B
11:53:35 PM 11:53:42 PM 0:00:07
12:18:43 AM 12:18:49 AM 0:00:06
12:41:20 AM 12:41:27 AM 0:00:07
01:07:01 AM 01:07:10 AM 0:00:09
01:31:38 AM 01:31:46 AM 0:00:08
01:37:33 AM 01:37:42 AM 0:00:09
01:38:25 AM 01:38:49 AM 0:00:24
01:38:51 AM 01:39:01 AM 0:00:10
01:39:01 AM 01:39:14 AM 0:00:13

Can you please suggest.

Thanks.

What results are you getting? That should work.

Thank for responding quickly,

I am getting the following results
when i Try this in column B
=INDEX(A:A,(ROUND(ROW(A1),0)*2)-1)
Try this in column C.
=INDEX(A:A,ROUND(ROW(A1),0)*2)

COLUMN B COLUMN C
0.995548495 0.995630671
0.01299919 0.013070718
0.028704167 0.028787153
0.046542477 0.046643634
0.063629167 0.063730671
0.067747685 0.067844907
0.068349074 0.06861794
0.068644097 0.068759259
0.068761227 0.068910417
0.069166551 0.069430208
0.069453935 0.076297917
0.076303009 0.076645833
0.076651042 0.085878704
0.088106829 0.088221528
0.088252546 0.088363657
0.088807523 0.088910185
0.088949537 0.089051157
0.092413773 0.092506829
0.092543403 0.092661458
0.105861227 0.105944907
0.12299537 0.123087269
0.138721528 0.138807755
0.15658287 0.156665394
0.173790625 0.173872106
0.177952894 0.178043171

Thanks.

Thanks khamilton,

It worked after formatting the columns.

Thanks.