Automatic date/time aquisition for graphs

Ok, I collect particle count data for a cleanroom which looks like th
following:

"LASAIR110","04/05/19","15:47:41",2700.0,45.00,"V6.3",0,0,0,1,433,486,236,113,294,196,103,328,4.993,1.0000,0.000,0.000,0.000,0.000,0.000,"22de"

"LASAIR110","04/05/19","16:33:15",2700.0,45.00,"V6.3",0,0,0,1,458,432,163,55,107,55,46,139,5.007,1.0000,0.000,0.000,0.000,0.000,0.000,2299

"LASAIR110","04/05/19","17:18:49",2700.0,45.00,"V6.3",0,0,0,1,305,286,76,29,14,1,0,0,5.017,1.0000,0.000,0.000,0.000,0.000,0.000,2224


Is there any way excel can read the .txt file and automatically impu
the date/time into a spreadsheet? Thanks in advance

--
Message posted from http://www.ExcelForum.com

0
5/21/2004 7:42:20 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
429 Views

Similar Articles

[PageSpeed] 57

If it always start with the same string and you could use

=--SUBSTITUTE(SUBSTITUTE(MID(A1,FIND(",",A1)+1,21),","," "),"""","")

format as mm/dd/yy hh:mm:ss

of course this assumes that your examples are in 3 different cells




-- 


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

"DrD525 >" <<DrD525.16mfsi@excelforum-nospam.com> wrote in message
news:DrD525.16mfsi@excelforum-nospam.com...
> Ok, I collect particle count data for a cleanroom which looks like the
> following:
>
>
"LASAIR110","04/05/19","15:47:41",2700.0,45.00,"V6.3",0,0,0,1,433,486,236,11
3,294,196,103,328,4.993,1.0000,0.000,0.000,0.000,0.000,0.000,"22de",
>
>
"LASAIR110","04/05/19","16:33:15",2700.0,45.00,"V6.3",0,0,0,1,458,432,163,55
,107,55,46,139,5.007,1.0000,0.000,0.000,0.000,0.000,0.000,2299,
>
>
"LASAIR110","04/05/19","17:18:49",2700.0,45.00,"V6.3",0,0,0,1,305,286,76,29,
14,1,0,0,5.017,1.0000,0.000,0.000,0.000,0.000,0.000,2224,
>
>
> Is there any way excel can read the .txt file and automatically imput
> the date/time into a spreadsheet? Thanks in advance.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>


0
terre081 (3244)
5/21/2004 7:57:11 PM
Hi,

I'm not sure I fully understand your question; if you
open the file from within Excel, and set as delimited
with comma, the date and time in fields 2 & 3 
automatically are read.

Are you looking for an automatic timestamp for when
the file is read in??  That is possible with a simple
macro.

jeff
>-----Original Message-----
>Ok, I collect particle count data for a cleanroom which 
looks like the
>following:
>
>"LASAIR110","04/05/19","15:47:41",2700.0,45.00,"V6.3",0,0
,0,1,433,486,236,113,294,196,103,328,4.993,1.0000,0.000,0.
000,0.000,0.000,0.000,"22de",
>
>"LASAIR110","04/05/19","16:33:15",2700.0,45.00,"V6.3",0,0
,0,1,458,432,163,55,107,55,46,139,5.007,1.0000,0.000,0.000
,0.000,0.000,0.000,2299,
>
>"LASAIR110","04/05/19","17:18:49",2700.0,45.00,"V6.3",0,0
,0,1,305,286,76,29,14,1,0,0,5.017,1.0000,0.000,0.000,0.000
,0.000,0.000,2224,
>
>
>Is there any way excel can read the .txt file and 
automatically imput
>the date/time into a spreadsheet? Thanks in advance.
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>
0
anonymous (74722)
5/21/2004 7:59:36 PM
Reply:

Similar Artilces:

system date returns null
Testing for the year returns a null using the system date. I am using Access2007. This worked in Access2003. My code is: 190 If Right(Year(Date), 2) = txtEYear Then txtEYear = "" When I run the code and check "date" with debug, it shows 'null'. On Sun, 14 Feb 2010 14:21:02 -0800, Dave <Dave@discussions.microsoft.com> wrote: That's unusual. Does your code compile? Check a code window > Debug > Compile. -Tom. Microsoft Access MVP >Testing for the year returns a null using the system date. I am using &...

Fixed Asset Import Multiple Times?
Scenario: We have a new client on GP 9.0, SQL 2005. They are just starting to use Fixed Assets. We are planning on doing the initial import of fixed assets via Excel and the Fixed Asset Import Wizard. However, they will have many acquisitions in the next few months/years of additional companies (from which they will acquire many new fixed asets at a time). Question: Can we do additional imports (from excel and the FA import/export wizard) for new/additional fixed assets we acquire during these acquisitions? We would want to maintain all our current Fixed Assets, of course, and j...

Changing the Default Activity Time
Hi I would like to change the default time shown when creating new Activities. The current default is 30 minutes. We woul like to reduce this to 5 mins etc depending on the Activity. Michael, You cannot do this in CRM by using the standard tools. You could try and edit the activity aspx page and use some client side scripting to change the picklist value at runtime. Regards, Rob Bakkers, Avanade Netherlands "Michael" wrote: > Hi > > I would like to change the default time shown when creating new Activities. > The current default is 30 minutes. We woul like...

How to set timer to expire at a given clock time (midnight, for example)
Is there a way to use SetTimer (or something else) such that a timer event occurs at the same time every day thanks bruce Look into waitable timers. You won't get a timer event, but you can have a thread block on it and when the block releases you can post a message that the timer has fired. joe On Fri, 28 May 2004 13:56:04 -0700, "Bruce" <anonymous@discussions.microsoft.com> wrote: >Is there a way to use SetTimer (or something else) such that a timer event occurs at the same time every day? > >thanks! > >bruce Joseph M. Newcomer [MVP] email: newco...

Re-post Didn't appear first time
Hi hope you can help! I have a number of copies/versions of the same spreadsheet (layout) which I now have to do a column content count on ie =countif(A1:A100,"A") but I only need to count this if another total in the same column is greater than 0 zero I can do this with an IF statement, but of course when I copy the formula into the other workbooks the original sheet reference remains. I thought I might be able to use INDIRECT() but can't see if this can be tied to an IF() As always any help or other suggestions would be welcome. Regards DonH donh, CountIF is looking i...

Combined bar/Line graph defaults to bar
In Excel 2007 I have a Combined bar/Line graph get it's data from a pivottable. Intermittently, when I change the pivottable filters, the combined bar/Line graph defaults to just a bar graph. I have tried 2 approaches with the same results - 1. Have the graph select each set of data from a range 2. Have the graph point generically at the pivottable and dynamically adjust itself -- Thank You in Advance, Michael Anderson Pivot charts are notorious for resetting their formatting when the table is refreshed or re-pivoted. What you have to do is change each series: right click on th...

Axis Break in Graph
Is there an excel macro, add-in or software package available for sale/download to create a graph or a chart with a broken axis? I am looking for a tool that is easily to use. Thanks! Priya, These are not automatic solutions but they will show you how to solve the problem. (http://www.geocities.com/jonpeltier/Excel/Charts/BrokenYAxis.html) (http://www.andypope.info/charts/brokencolumn.htm) For line chart see, (http://www.tushar-mehta.com/) Priya wrote: > Is there an excel macro, add-in or software package > available for sale/download to create a graph or a chart > with a...

Automatic marking messages read
I am using Outlook XP. How do I change the amount of time I have to look at a message in my inbox before Outlook automatically marks it as read? I know how to mark it as read manually. Daniel L Newhouse <danielnewhouse@bellsouth.net> wrote: > I am using Outlook XP. How do I change the amount of time I have to > look at a message in my inbox before Outlook automatically marks it > as read? Tools>Options>Other>Reading Pane >I know how to mark it as read manually. Edit>Mark as Read. You would do well to peruse your menus and options and to read the Help th...

Automatic addition to payee list
I travel all the time in a motorhome, and use Visa for most expenses. I download my Visa transactions as QIF files and import them into Money 2003. My problem is that Money automatically adds each new payee to the list of payees. My list of payees just keeps growing and Growing and GROWING..... Does anyone know of a way to stop the automatic addition to the list? I know I can manually remove them, I would just rather they weren't added in the first palce. Thanks, Bill See http://www.bollar.org/msmoney/#Q63. "Travel'n Bill" <anonymous@discussions.microsoft.com...

Clicking a cell...... automatically to another cell?
Is it there a formula, that if you click on a Cell, you automatically go to another Cell in that worksheet? (without using a macro?) Ruud Hi# try usig a hyperlink ('Insert - Hyperlink') >-----Original Message----- >Is it there a formula, that if you click on a Cell, > you automatically go to another Cell in that worksheet? >(without using a macro?) > >Ruud > > >. > You could also use an =hyperlink() formula. David McRitchie posted this and it might help you: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#...

Format a Date Using Field Properties
I know how to do this in Visual Basic and Assembler but having trouble with the Syntax in Access On the Format Event on the Properties Menu for a Field I have ("mm/d/yy") I have been guessing and trying to find an example on the WEB and in Access Help and still cannot determine what I am doing wrong. All I want to do is display the year as two characters instead of four! On my Format Tab, On the Format Line (The first line) What Syntax does it want to do this very simple task! Thanks in Advance Len mm/d/yy (no quotes) -- Doug Steele, Microsoft Access MVP http://I.Am/Do...

Automatic Pareto data with Formula
I want to create a data table for use to create an Automatically updated Pareto Chart, for this I need that the values automatically be sorted in descending order, so I have the following example scenario: Column A has Labels and Column B has Values A -1 B -2 C - 3 D - 2 E -1 If I use the following formula: =INDEX($A$1:$A$5,MATCH(LARGE($B$1:$B$5,2),$B$1:$B$5,0)) I get B, but there are two 2 and if I use the 3rd largest: =INDEX($A$1:$A$5,MATCH(LARGE($B$1:$B$5,3),$B$1:$B$5,0)) I also Get B instead of the required D. How can I get it so the end results looks like this: C ...

Convert Date Format
I receive data with the date format as "20051106" [6 Nov 2005] which is OK for me but end users want to see it in the more conventional "dd/mm/yyyy" format. How can I transpose the data and insert separators. Tks Mike You could use a formula such as =RIGHT(E20,2)&"/"&MID(E20,5,2)&"/"&MID(E20,3,2) assuming your data was in cell E20 HTH -- _______________________ Naz, London "Mike" wrote: > I receive data with the date format as "20051106" [6 Nov 2005] which is OK > for me but end users want to see ...

Graphing in EXCEL
I have a question to do with graphs. For example here is my data 1 apple 1 banana 1 grape 2 orange 2 grape 3 banana and I want EXCEL to graph it exactly this way (See below) (with the data labels included) (sort of like a scatterplot but not quite) X orange X apple X banana Xbanana X grape Xgrape .......................................................... 1 2 3 How do I do this? Please please answer my question. Thanks a lot in advance! If I cant do this ...

Auto enter date?
Hi! me again! is there any way i can get excel to auto enter dates that jump by 7 days every 7th cell along? cheers steve Ive worked part of this out. in cell G1 =DATE(105,1,3) in cell M1 =G1+(WEEKDAY(G1)>=1)*7-WEEKDAY(G1)+1 but its displaying the time...i just want the date.... steve "R.P.McMurphy" <rpmcmurphy@ntlworld.com> wrote in message news:43118dff$0$17506$ed2e19e4@ptn-nntp-reader04.plus.net... > Hi! me again! > > is there any way i can get excel to auto enter dates that jump by 7 days > every 7th cell along? > > cheers > > s...

using time
Having a problem using time in my calulation. Trying to find out the number of people that past a point for 1,2,3,4,5,6,7,8,9,10,15,20,30 minutes in columns head while I have 55, 100, 160 and 200 in rows. I have sum=(55*(60/col)) Col 1 2 3 4 5 6 7 8 9 10 15 20 30 minutes 55 3300 102 155 300 Then I want to use 5,000 divided by the rows/cols further down the sheet using the same time figures. I try doing sum=(5000/row/(60/col)) where the results should climb as the time gets higher, but results is off/ Col 1 2 3 4 5 6 7 8 9 10 15 20 30...

Time Table Problem
Hi, I'll try to give as much detail as I can on this problem in order to increase possible solution alternatives. In a excel workbook, I have 4 Lists on Sheets 1, 2, 3 and 4 column A:A respectively. The list on Sheet1 shows "names of teachers". The list on Sheet2 shows periods (10 periods for each 5 working day of the week) that can be used throughout the week e.g (Mon1, Mon2, Mon3,...., Mon10), (Tue1, Tue2, Tue3, ....,Tue10), .........., (Fri1, Fri2, Fri3, ...., Fri10) totalling to 50 periods. The list on Sheet3 shows the lesson names+classes to take it (in the format lesson...

How to login first time from client
I installed the server GP10.0 and created the users. Instlled Clinet software and can test ODBC connection successfuly. I started GP . it asks me to run the GP utility, if i login with user account i created in SQL, it asks me to login as sa account, if i don't chose to run the GP utility it will quit and i don't get any login page, please HELP Login with the 'sa' account! Best regards, -- MG.- Mariano Gomez, MIS, MCP, PMP Maximum Global Business, LLC http://www.maximumglobalbusiness.com The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com "Rak"...

Dates 06-18-07
My problem: I am trying to have one date minus another date. I want to display the difference in days. Help! -- TeeDEe Hi DateDiff("d", [StartDate], [EndDate]) HTH -- Wayne Manchester, England. "TeeDee" wrote: > My problem: I am trying to have one date minus another date. I want to > display the difference in days. Help! > -- > TeeDEe ...

Login time to Dynamics GP
We upgrade dot Dynamics GP and now the login time for several users is very long. It is taking most users several seconds, 3-10 to log in. For some others it is taking minutes to get into the system for them to be able to work. I have not found anyhting on Customer Source and have not heard back from Microsoft yet. Does anyone have any ideas? We are connecting to GP via citirx connections on a windows 2003 box. Thanks, ConfusedAdmin Backup Dynamics database (to be safe) Delete from dynamics..SY07110 Login as admin and you will see good speed again. I must do this every month t...

Convert text to time format
Hey, I am unable to convert a piece of text that i copy paste from an external source to time format. Suppose I copy, "July 24 2006, 05:31 PM" and paste the same in excel it just assumes that that the entered data is text and I am unable to format the same. I need to convert this to the time format for proceeding with certain calculations. PLease help.:mad: :mad: +-------------------------------------------------------------------+ |Filename: TTT.zip | |Download: http://www.excelforum.com/attachment.php?postid=5111 | +-------...

Pivot and Graph
I have a pivot table displayed with data populated using c# code. I want to create a graph out of ONLY the FINAL summary rowS. If I create a pivot chart, then it gets messed up if I expand the pivot table. If I manually copy paste the sumary values into another place and draw a graph based on that, then when the pivot table data is re-updated by c# code, then my graph would go out-of-sync. If I refer to the summary cells somewhere and use that for the graphing, then also when I expand/collapse the pivot table, then the location of the summary rows change and so my graph goes blank. One pos...

Automatic BCC possible with Outlook?
I've just switched to using Outlook, and discovered there doesn't appear to be a way to always BCC myself. Is there a way to do this, that I just haven't figured out yet? Thanks, Don ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- See if this helps: http://www.outlookcode.com/d/code/autobcc.htm "Don" <no@adr.com> wrote in message news:ere1b1tjqf2j78sn7kauiudrpepard6qgo@4a...

How to delay ToolTip display time in CListCtrl Control
I create a CListCtrl object with LVS_EX_INFOTIP and Report style the Tooltips display time is too short, how to delay ToolTip display time in CListCtrl Control CListCtrl::GetToolTips() returns the CToolTipCtrl Control CToolTipControl::SetDelayTime() sets the delay time. Ali R. "Smallfrogs" <super_smallfrogs@hotmail.com> wrote in message news:uAOl3Tj9DHA.440@TK2MSFTNGP10.phx.gbl... > I create a CListCtrl object with LVS_EX_INFOTIP and Report style > > the Tooltips display time is too short, how to delay ToolTip display time in > CListCtrl Control > > C...

Incorrect time on Outlook account
Hi On one of my Outlook accounts, whenever I receive a message it shows the time being 6 hrs in front. I contacted my provider and they say their server times are all correct. If it was showing a server default, the timezones we are in means it would show as arriving 6 hrs behind?? It only shows the incorrect time on the inbox page -when I open the message the time is correct?? Another account I have with another provider does not have the same problem so it has to be at their end??? Any help would be appreciated. In news:FD02E331-7F02-43B0-BBA1-ACF2615A6B0F@microsoft.com, snoopdug...