LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dan is offline
external usenet poster
 
Posts: 866
Default Formating a timestamp as a date and time.

I have imported some data into excell and it is currently looks like this
2006-09-26-11.16.38.902000 I am trying to compare ir get the difference
between two of these timestamps but excell doesn't receognize this format.
What is the easiest way to make this timestamp work? I am using excel 2000.

 
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
Converting UTC timestamp value to date and time SK Excel Discussion (Misc queries) 1 March 19th 07 02:40 AM
Calculate Elapsed time: difference between 2 Date/Timestamp perio beadedbeauty Excel Worksheet Functions 4 August 24th 06 04:49 PM
synchronizing timestamp feature with time on video software. 999 Excel Discussion (Misc queries) 4 July 30th 06 10:49 PM
Convert Unix timestamp to Readable Date/time Emily Excel Worksheet Functions 2 January 26th 06 11:59 PM
Calculating days & time left from start date/time to end date/time marie Excel Worksheet Functions 7 December 7th 05 02:36 PM


All times are GMT +1. The time now is 05:11 AM.

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"