| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formating a timestamp as a date and time.
Transform it
=DATE(LEFT(A1,4),MID(A1,6,2),MID(A1,9,2))+TIME(MID (A1,12,2),MID(A1,15,2),MID(A1,18,2)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dan" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formating a timestamp as a date and time.
What does this represent?
I am guessing it is Sep 26th 2006 at 11:16:38. What does the .902000 refer to? If you import it as 2006-09-26 11:16:38 Excel recognizes it. (put space between day and hour and put colon instead of period between hour, minute and second. Hope this helps. "Dan" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formating a timestamp as a date and time.
Bob thanks for this info, it worked great, and I was able to get the info I
needed. "Bob Phillips" wrote: Transform it =DATE(LEFT(A1,4),MID(A1,6,2),MID(A1,9,2))+TIME(MID (A1,12,2),MID(A1,15,2),MID(A1,18,2)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dan" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting UTC timestamp value to date and time | Excel Discussion (Misc queries) | |||
| Calculate Elapsed time: difference between 2 Date/Timestamp perio | Excel Worksheet Functions | |||
| synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
| Convert Unix timestamp to Readable Date/time | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Linear Mode
