Thread: Time Entries: Want to Skip the ":"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brian Handly
 
Posts: n/a
Default Time Entries: Want to Skip the ":"
I have a time sheet with Start and Stop times. I want to enter 22:00 as
"2200". However, EXCEL does not recognize "2200" as a time. How can I
force it to recognize it as a time or how can I convert it to a time?

Texas Handly
Reply With QuoteReply With Quote