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?