How to fill missing enteries in column A, and add respective corresponding enteries to column-B with value of previous cell
try to make a sheet derived from the source. first, put all possible time in the new sheet in an ordered way. second, do vlookup from source for value. third, put vlookup inside a iferror to find missing value and for second part of iferror use previouse value.