False to True Transition Calculation

[Sparky2000]

Good Day All,
I am new to this Forum and this is my First ever post.
I am trying to find out if I could calculate the time differences between 0 to 1 Transitions in a Column.Sample of the File is attached.
A file such as the one in the attachment is created at midnight everyday.This happens on one of the computers for Data Acquisition on a machine.
I have been asked to calculate the time intervals every time a transition from a 0 to a 1 (Blue Arrows) happens. This file is updated every three seconds (red arrow) as shown in the attachment.The times calculated can be stored in Column D.(where the Blue Arrows are located in the file).
Just before midnight, I would like to save this file (new file name) with the date, the rows with Transitions only and the calculated Time Intervals.This file has to be emailed to a group of users in our factory.
Right after midnight, a new file is created and overwrites the original file.
Is this possible to do using Excel VBA?
Any help or suggestions will be appreciated.
Thank you all in advance.