vba - Calculate seconds from two datetime

Question

I want to write a excel macro, which should calculate the seconds from the two datetime.

I have the following format of datetime in a single column.

DateColumn
--------------------------
2010-01-10-01.07.24.465000
2010-01-10-01.08.25.575000

How to calculate the how many seconds difference in the above datetime using macro?

Answer 1

You are looking for Datediff() Function.

Here you got some documentation. You can choose seconds in the first parameter

Anyways it is better and easier to do this by formula.