Thread: how do I convert a general number to a time format?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Sheldon
 
Posts: n/a
Default how do I convert a general number to a time format?
You can parse the string with
=LEFT(A1,2)&":"&MID(A1,3,2)&":"&RIGHT(A1,2)

Dave

"doveness" wrote in message
...
I'm trying to conver 425033 to 42:50:30

I'm running out of steam!


Reply With QuoteReply With Quote