xor, that seemed to work man. thanks a lot!
now can you tell me how to delete the original data after i get the new column of data created with the formula. if i go to delete the original column, the new column with the times in the front of the cell get all messed up. or is there a way to use the formula in the second column and have it change the data in the first column instead of just creating the new data in a newly created second column?
|