View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ellen
 
Posts: n/a
Default Time formatting:data 1:30:20 entered reads in 1:30:20 pm

I am trying to get data entered in format 1:30:25 etc... to read 1:30:25 PM
but it keeps reverting back to am.