I am currently using 
Range("$AA$2").Formula = "=AF3/86400"
to convert 383.764221191 to 0:06:24. I am trying to get the value of cell AA2 converted as text in cell AA4. I have done some searching and there was mention of adding .text to the range; however, I receive an invalid use of property error.

Thoughts?