Thread: Add colon to time automatically, still recognize it as time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] kellye.smiley@gmail.com is offline
external usenet poster
  
Posts: 1
Default Add colon to time automatically, still recognize it as time
Good morning! I need to type 0125 into a cell and it automatically add the colon (01:25 or 1:25- Either works). I have found several solutions to this BUT I also need Excel to still recognize the cell as "Time" so I can figure elapsed time in another cell. Thank you!
Reply With QuoteReply With Quote