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?
See Question&Answers more detail:os