Add in missing seconds between timestamps

**macronewbie9981** · 08-24-2016, 01:15 PM

My data looks like:

Time Num
08:56:59 0.03
08:57:04 0.63
08:57:09 0.72
08:57:14 0.11

I wnat to fill in the missing seconds. is there a way to do this automatically? My file has 1000s of rows. A snippet of the data is attached.

**MrShorty** · 08-24-2016, 01:27 PM

Step 1, use the TIMEVALUE() function to convert the text string "time" in row2 to a real time value. https://support.office.com/en-us/art...d-f3eb6d186645
step 2, add a function like =reference to step 1+TIME(0,0,1)
step 3, copy step 2 down as far as needed.

I just realized that you are posting this in the VBA forum. Same steps apply, just use the VBA functions instead of the Excel worksheet functions. https://msdn.microsoft.com/en-us/lib.../gg278435.aspx