Thread: Time format problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sandy sandy is offline
external usenet poster
  
Posts: 5
Default Time format problem
the time like
9:00:00AM was displayed as 4292552277.375 in excel
12:00:00PM was displayed as 4292552277.5 in excel

Can any one help me how to display in normal format
9:00:00AM ?
Reply With QuoteReply With Quote