I have a similar problem with telephone call records, and I need to
convert them into a standard format. With the raw data in one sheet, I
copy just one column (A) of data into the conversion sheet - here there
are formulae ready to be copied down to do the conversions. All I need
to to is double-click on the fill handle for each cell at the top of
each column, and the formulae are replicated down only for as many rows
as there are entries in column A.

Hope this helps.

Pete