ok, her is what I have
E F
14:00 15:00

I want the out put to look the same only converted to text in the l
column. I can do it with formulas in each cell, but when I try to get
VBA to drop the formulas in the cells, it errors. I am using:

Range("l1:l4000").FormulaR1C1 = _
"=text(RC[-4],"[h]:mm")"

Range("m1:m4000").FormulaR1C1=_
"=text(RC[-4],"[h]:mm")"

basically it is seeing the " and taking that as the end.

Any ideas?