Thread: How do I convert a # into a time format in Excel, Ex.845 to 8:45
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
twilliams
 
Posts: n/a
Default How do I convert a # into a time format in Excel, Ex.845 to 8:45
I have tried to format the cell with a time format. It brings up my times
all as 0:00. I want them to convert to time without me wasting time to enter
the colon between the numbers every time. I want them to convert for example
845 to 8:45.

Can you help me?
Reply With QuoteReply With Quote