I want 1:00 pm and i keep getting 1:00:00 pm
how do i get rid of the seconds part in a long column of time?
formating the cells does not do it.
thanks