Try a variation of the formula I gave you like this:
=LEFT(TEXT(TIME(HOUR(A1)+B1,0,0),"h AM/PM"),2)

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Emerogork" wrote:

Thanks to everyone with your quick and insightful responses. I have made
great progress in my project.

Can anyone help me refine this one?

Michael wrote:
To solve the first issue select the cell or column where the time is, then
from the Main Toolbar Menu, select:
Format - Cells;
by default you should be in the number tab, if not just click on it.
Click on Custom and key-in an "h" no quote marks this will display your time
as 7

3:00pm becomes 15.

Almost there, can I get 15 to show up as 3?