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