Stephen,

You need to describe your workbook, and show sample data. It appears that
you are simply trying to replace times entered as decimal hours with actual
times. Why are you skipping cells?

A SMALL sample of your data table would help. Put up, say, 2 columns by 10
rows of data, and what you want as a result, and it would be much easier to
code. When you say that the above pattern is repeated 14 times, where is it
repeated? On the next column? 2 columns over? 100 rows down?

HTH,
Bernie
MS Excel MVP



Here is my Code: