Thanks much for your help. I'm closer now to what I need. Can you explain
how to perform the adding 12 hours via a helper column? Thanks

"Fred Smith" wrote:

There's no problem with the AM time. You can enter hh:mm, and format it the
way you want.

With the PM time, if you don't need to use the number as a time, you can use
a custom format of:
hh:mm "pm"

If you need to work with the data as a time, then you would need to add 12
hours to the PM time, either with a macro or a helper column.

Regards,
Fred.

"bgcooker" wrote in message
...
I want to be able to enter a time as a 12-hour time in one column of cells
and have the time entered as formatted as AM. I want to do the same in
another column of cells and have those cells format the time as PM. How
do I
accomplish this?