Thread: How do I keep excel from changing minute and second times into AM.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default How do I keep excel from changing minute and second times into AM.
Enter 0:20:02

--
Kind regards,

Niek Otten

"Jake" wrote in message
...
I am having a problem with Excel
I put times in as minutes and seconds, and attempt to use the format cell
command and have tried every option under time and custom.
The program keeps reading 20:02 (20 minutes and two seconds) as 10:02 PM,
how can I keep this from happening?


Reply With QuoteReply With Quote