Thread: changing time format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JT[_2_] JT[_2_] is offline
external usenet poster
  
Posts: 96
Default changing time format
I have a spreadsheet where the time is displayed as 0405P
or 1115A.

What code can I use to change the time to 04:05:00 PM or
11:15:00 AM?

Thanks for the help.
Reply With QuoteReply With Quote