change time formating

J

just me

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
 
F

Fred Smith

Formatting the cells has to work, unless the cells have text in them, rather
than a number. Try changing one of your cells into a number, by using a formula
like =a1+0, then format this cell as a time (hh:mm am/pm). If this works, then
you need to change your cells from text to a number before formatting will work
on them.
 
Top