I have a breakpoint time series (when monitored value changes a new timestamp is created), which is created using accuracy of 1 second (time stamps in form of yyyy:mm:dd:ss) and I'd like to change that time series to 1 second resolution time series.

Basically this means adding additional rows and timestamps in between breakpoint timestamps, and these new timestamps need to hold the last value of the monitored entity.

Example
Breakpoint time series
[Breakpoint](https://i.stack.imgur.com/4VhEX.png)

Wanted 1 second res time series
[1 second res](https://i.stack.imgur.com/CH24J.png)

etc. I hope you get the idea.

Problem is that I don't know how to get started with this issue, I haven't been able to find that many similar cases from the archives.

What could be a good way of approaching this type of dilemma, and how to implement the described solution as a code for VBA?

Any help is appreciated.

Thanks
BR
Muje

EDIT:
I have created a short script that can add missing rows and duplicate the value above to this new row. However I am still struggling with cases where there is more than 1 second missing from the break point time series. Code below:

```
Option Explicit
Sub BP_to_sec()

Dim wb As Workbook
Set wb = ThisWorkbook
Dim ws As Worksheet
Set ws = wb.Sheets("Test")

Dim LastRow As Long
Dim RowStep As Long

Dim S As Double
S = (1 / 86400)

LastRow = Range("A" & Rows.Count).End(xlUp).Row
 For RowStep = LastRow To 3 Step -1
   If Not IsEmpty(Range("A" & RowStep)) Then
     If (CDate(Range("A" & RowStep)) > (CDate(Range("A" & RowStep - 1)) + S)) Then
       Range("A" & RowStep).EntireRow.Insert
        Cells(RowStep, 1).Value = Cells(RowStep - 1, 1).Value + S
        Cells(RowStep, 2).Value = Cells(RowStep - 1, 2).Value
     End If
   End If
 Next

MsgBox ("Sorted")

End Sub

```