+ Reply to Thread
Results 1 to 2 of 2

Timestamp format

Hybrid View

  1. 06-24-2009, 12:44 PM #1
    MedTech
    MedTech is offline
    Registered User
    Join Date
    06-24-2009
    Location
    Oklahom
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question Timestamp format

    Help!
    My date/time data is exported in this format 01/16/2009 8:01AM. I need it in this format 39829.33403. How can I insert a space between the time and AM in large quantities of data in order for it to automatically convert to the time stamp format?
    Reply With QuoteRegister To Reply
  2. 06-24-2009, 12:51 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Timestamp format

    Welcome to the forum.

    You could use a formula: =(LEFT(A1, LEN(A1)-2) & " " & RIGHT(A1, 2) ) + 0 and format the result as 0.00000

    Or select the column, replace AM and PM with " AM" and " PM" (sans quotes), and format as above.
    Last edited by shg; 06-24-2009 at 12:54 PM.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1