My data looks like:
[TABLE="width: 230"]
Time
[/td]Num
[/td]08:56:59
[/td]
[TD="align: right"]0.03[/TD]
08:57:04
[/td]
[TD="align: right"]0.63[/TD]
08:57:09
[/td]
[TD="align: right"]0.72[/TD]
08:57:14
[/td]
[TD="align: right"]0.11[/TD]
[/TABLE]
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.