.... or just +0.5 (as 12 hours is 0.5 of a day).

You can either add 0.5 in the formula, or put 0.5 in a spare cell and copy
it, then select the column of data to which you want to add 0.5, and Edit/
Paste Special/ Add.
--
David Biddulph


"Fred Smith" wrote in message
...
You would type, say, 9:32 into cell b2. In the c2, use the formula:
=if(b2="","",b2+time(12,0,0))
and format the cell as you prefer (like h:mm am/pm)

Copy the formula down, and use column C in all your calculations.

Regards,
Fred.

"bgcooker" wrote in message
...
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?