i asked earlier about how to change text to time in a cell, and the solution was given to me (thank you Debraj Roy), but after marking as solved i copied the cell down, but a new problem came. if the cell already had a time in it, it left the new cell blank. so i altered the formula to read

PHP Code: 
=IF(P6="","",IF(CELL("format",P6)="d9",P6,TIMEVALUE(P6))) 
which i think should have worked and q6 did show a time value, but my time calculations failed. did i do something wrong?