View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
dlw
 
Posts: n/a
Default How do I convert a time to text format.

excel uses a serial number format for times (makes calculations easier) you
have to convert it using: =text(a1,"hh:mm:ss")

"Rick" wrote:

I want to get a list of times into another database program. But the time
formatting is getting messed up. For example. A time of 0:31:10 when
imported into the other program becomes 0.021643519. How do I convert the
time into a text format that can be exported?