I would like to input a time without the seconds showing
Thank you but in doing so it converts the time to a 24 hour clock and I need
it to remain 12 hour (2:00 PM vs 14:00)
Tara
"Roger Govier" wrote:
Hi Tara
FormatCellsNumberCustom h:mm
--
Regards
Roger Govier
"Tara" wrote in message
...
I have tried to format the cell by using both general and time formats.
When
using h:mm AM/PM the seconds till show up. I am using this for a mail
merge
and don't want the time to reflect seconds.
|