LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rick
 
Posts: n/a
Default How do I convert a time to text format.

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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert Text numbers to time format jermsalerms Excel Discussion (Misc queries) 3 January 20th 06 12:03 AM
Excel should format time down to the hundredth/sec. John Krick Excel Discussion (Misc queries) 3 November 28th 05 09:23 PM
Format Number to Text Roni Excel Worksheet Functions 2 May 17th 05 03:17 PM
Everytime I need to format cells or text, Excel 2003 takes a lot of time or free Florimar Agostini via OfficeKB.com Excel Discussion (Misc queries) 1 April 1st 05 06:29 AM
Convert text file to MS_Excel Aqua Flow Excel Discussion (Misc queries) 1 November 30th 04 02:55 AM


All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"