time format

[Guest]

I have a column for time in my spreadsheet. The value are as follows:

4:10:18 PM
10:29:30 AM
1:57:33 PM
10:13:20 AM

I would like to programatically change them to the following values:

04:10 PM
10:29 AM
01:57 PM
10:13 AM

I'm having trouble getting the results I want. When I fill a variable with
the hour for 4 PM, the value is 16.

Any suggestions would be appreciated. Thanks for the help.

 

[Guest]

did you try to refromat the cell using the format menu - cells - number -
date. there are lots off date formats that are avvailable.