converting times

[JT]

I'm trying to convert times in a spreadsheet (1:15:00 PM
to 0115P and 11:45:00 AM to 1145A) but am not having much
luck. Any suggestions on a formula to make this
conversion would be greatly appreciated. Thanks for the
help....JT

 

[Harald Staff]

Hi JT

Time is time, what you see is simply a graphical presentation of it. I take
it you mean that 1:15:00 PM and 0115P is the very same value, so no
conversion should be done. Just format the cell as custom format hhmmA/P .

HTH. Best wishes Harald