Insert missing time in between rows

  • My data looks like:


    [TABLE="width: 230"]

    [tr]


    [td]

    Time

    [/td]


    [td]

    Num

    [/td]


    [/tr]


    [tr]


    [td]

    08:56:59

    [/td]


    [TD="align: right"]0.03[/TD]

    [/tr]


    [tr]


    [td]

    08:57:04

    [/td]


    [TD="align: right"]0.63[/TD]

    [/tr]


    [tr]


    [td]

    08:57:09

    [/td]


    [TD="align: right"]0.72[/TD]

    [/tr]


    [tr]


    [td]

    08:57:14

    [/td]


    [TD="align: right"]0.11[/TD]

    [/tr]


    [/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.


    forum.ozgrid.com/index.php?attachment/70035/

  • Re: Insert missing time in between rows


    After removing the stray items down around row 4500...
    try this on your test file

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!