change time formating
 

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

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.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"just me" <just wrote in message
...
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