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
443 Views

Similar Articles

[PageSpeed] 41

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:

Adding Lines automatically
I have hundreds and hundreds of products already sorted in a spreadsheet, and I was wondering if anyone knows how to insert (lets say 4 or 5) lines in between each product (if sorted by product name) automatically. I understand that you could go one by one w/all the products and insert them in manually. But is there anyways to do that on excel or anyway to trick the program and exercising this function. If someone could get back to me if they know, that would be great. Thanks There's probably a much easier way but this macro should do it. Select the first cell in the column t...

Adding contacts to distribution lists automatically
I would like to add several hundred contacts to distribution lists based on categories. I only need to do this once (I have Send Personally from mapilab to handle future subscriptions) but the idea of changing existing contacts manually makes my head spin...any ideas on how to automate this? I'm using Outlook 2000. Thanks for your help! Lisa My question is why would you want to do this? DL's are buggy, featureless and inflexible. Since you've created Categories already, why not use those instead of DL's? -- Russ Valentine [MVP-Outlook] "Lisa" <lpb@xtra.co.nz&g...

Graphing Question #4
Greetings! I am trying to graph a set of data in 'XY (Scatter)' and am running into a problem I've never seen before. There are only seven values for 'X' - numbers 0 through 6. 'Y' is a set of percentages ranging from '0.00%' to '13.00%' I have about 7,000 of these pairs. When I graph this, I am not of seeing the six discreet bands of percentages that I would expect. For some reason, instead of graphing the 'X' value, it is graphing the order that the 'Y' value comes in the list. Instead of graphing: RATING INCREASE 4 ...

Print Assistant change Start time
I use the Calendar print assistant to print my calendar. I normally use Long Week 01 or Standard Week 02 templates. The calendar starts at 8am. Is there a way to change this to 7am. My Outlook calendar shows a start time of 7am. Is there any way to further customize these templates. Thanks Kristy You can edit the XML - See http://www.slipstick.com/outlook/ol2007/editcpao.asp for instructions. I have not looked into changing the start times so I don't know where to tell you to look. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ O...

Calculating a Date
I have two fields in a query: "Date Completed" (mm/dd/yyyy) and "Time Used (hours)" (nn.n). I am trying to calculate a third "Date Started". Assuming an eight-hour day, I am trying to use the expression [Date Completed] - [Time Used (hours)]/8 but I can't figure out which Date/Time functions to use to convert my dates and hours to the same units to do the calculation and then back to a date again. I am using Access 2007 and am not all that competent with it. Thank you in advance for your help! You can try the following. DateValue(DateAd...

Changing Year in Date Range
I am using a crosstab query for selecting data for a date range spanning 12 months over two different years using a "Between & And" date range e.g Between #01/04/07# And #31/03/08# For the following 12 month period I can manually change the Year numbers in the above criteria. my question is: is it possible to change or select the Year number without having to change it manually in the query design view by say a parameter box? Have you considered using this --- Between CVDate("4/1/"&Format(Date(),"yyyy")) And CVDate("3/31/"&Format(Da...

Which computer program is best to tally time spent on each project
Does anyone know which computer program is best to tally time spent on each project so that I can keep a running total? Do I need to set up an excel spred sheet to do this? Is there something connected to a dayplanner program that would allow this? thanks Sounds like MS Project to me. -- HTH RP "antiamazon" <antiamazon@discussions.microsoft.com> wrote in message news:7848A00B-3103-4E82-A4C8-F3E664F8A5EA@microsoft.com... > Does anyone know which computer program is best to tally time spent on > each project so that I can keep a running total? > > Do I need...

First time user
I bought a computer that came with a version of Microsoft Money. I was wandering how good this program is. I have used Quicken before, but never Money. I was debating on which one to use. Any help would be greatly appreciated. Thanks. In microsoft.public.money, Greg wrote: >I bought a computer that came with a version of Microsoft >Money. I was wandering how good this program is. I have >used Quicken before, but never Money. I was debating on >which one to use. Any help would be greatly appreciated. You can use both for a while and decide. To really appreciate Money, y...

Counting how many times a number appears in a list?(EXCEL)
hi, got a small problem in excel, situation as below: grade 1 2 3 1 2 1 2 3 4 1 1 what formula do I use to count how many times (e.g) 1 appears in th list? I thought I could do it with the Count function but haven managed to. Cheers -- Message posted from http://www.ExcelForum.com The "countif" formula should do! Dunca -- Message posted from http://www.ExcelForum.com =COUNTIF(A1:A15,1) -- Regards, Peo Sjoblom "sox >" <<sox.152stn@excelforum-nospam.com> wrote in message news:sox.152stn@excelforum-nospam.com... > hi, got a small problem in excel...

How do I keep text from automatically filling in another text box
When I fill in a text box, the same text automatically appears in another text box. I don't want that to happen. I want each box to be filled independently. Thank you. Click in the test box that you don'e want the text to continue and then click the "broken chain link." "Chicago" <Chicago@discussions.microsoft.com> wrote in message news:9C5E740A-1C10-4DAC-9B78-ED2898E9EEEE@microsoft.com... > When I fill in a text box, the same text automatically appears in another > text box. I don't want that to happen. I want each box to be filled > in...

Outlook time stamp different from OS
I have a user who's outlook time stamp is out of sync with the OS time stamp. This occured at the daylight savings time switch over. Does anyone know how to resolve this? does outlook, windows, and the server all have the same time zone configuration, including the DST setting? -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com "HLi CS" <anonymous@discussions.microsof...

converting date and time fields
Hello, I have columns that contain date and time in the "14/07/2003 17:57:00" format. I need to convert them into date-only and time-only fields (not only visually). How do I get rid of the date/time part? Thanks thanks! "Laura Cook" <laura@top-brands.com> wrote in message news:eP$BBBzZDHA.2648@TK2MSFTNGP09.phx.gbl... > With date and time in column A, in B1 enter: > > =INT(A1) > > Format as a date. Now in C1 enter: > > =A1-B1 > > Format as a time. > > Copy the formulas down as far as needed. If you no longer need column A, > ...

How can I turn off the automatic ordering of the data in Pivot Cha
I have some data, which I would like to rearrange in the chart, but it's automatically re-ordering it. I have tried manually re-ordering the data, but that's not helping. The Pivot chart seems to automatically override what order I put the data in, and charting it as it wants. I have tried unchecking the Automatic Formatting, but no change. Help? ...

Query Date Range
How can I use Between/And to prompt for date range that includes the start and end date? Hi, Design a select query for your table. add all fields to the design grid. In criteria box of the date field write this Between #BeginningDate# And #EndingDate# and run the query to find results. JB "karenfocus" wrote: > How can I use Between/And to prompt for date range that includes the start > and end date? My current criteria is in a query date field and is written Between [Enter start date] And [Enter end date] but when I run the query from the first day of the month to the...

Date order #2
I was wondering how i sort dates in time order. I am making a bowlin score average sheet and I have put the scores in, but not i chronological order. I have five colums across and was wondering i when i sort the dates will all the other information stay with the sam date. Thank -- scottnoddin7 ----------------------------------------------------------------------- scottnoddin77's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2665 View this thread: http://www.excelforum.com/showthread.php?threadid=39932 Scott, If you've typed bona-fide dates, they'll s...

Date Conditional in Javascript
I have a date-only attribute called CFDDateReceived that I was setting to the current date in an OnLoad event script as follows: crmForm.all.CFDDateReceived.DataValue = new Date(); It worked fine when creating new cases, but it was also resetting existing case dates. I have tried every which way I can think of to change this statement to a conditional. My latest effort as follows: if (crmForm.all.CFDDateReceived.DataValue == "" ) {crmForm.all.CFDDateReceived.DataValue = new Date();}; I know it's got to be somethiing simple, but it seems to be beyond me. Ca...

Charting/ Graph question
Hi all I'd like to visually display a table that contains the following table structure StaffName Software 1 Skill Level Software 2 Skill Level (10 software titles >) (around 50-60 people) What i'd like to is output a simple visual output that shows me how many people are at a particular level for the each software (but all on one chart). I imagined that it may be nice to see blobs based on the size of the number of staff at a particular skill level for the specific software. However i am not sure if this is the right way to represent this data. I've created a se...

Access the "automatically suggest a name to enter" data ?
When typing in a name in a new e-mail, Outlook automatically suggests a name to enter, and I like this. However, I have many in there that I would like to add to my contacts. At present I do not want to type in "a" and then sellect one, then add it to my Outlook contacts etc and then repeat all they way through to "Z" Other than doing this ONE at a time, is there another way? Thanks You can't even add them one at a time the way you suggest. You can only add your autocompletion cache to your Contacts using third party software. http://www.ingressor.com/deskt...

how do i export a graph from excel to power point?
i am trying to export a graph from excel into my presentation in power point. Is there a way to do that? lisajensen21 Wrote: > i am trying to export a graph from excel into my presentation in power > point. > Is there a way to do that? Hi. Just click on the chart so that you get black dots at the corners and mid points of the chart Then go to Edit - copy. Open the powerpoint page you want and then make a text box Click inside the text box and then go to Edit - paste. HTHs -- badkitti* ------------------------------------------------------------------------ badkitti*'s ...

Removing Dialog Item at Run Time
Is it possible to remove a Dialog item from a Dialog at run time? This code does not work, but I don't know why: BOOL CMyDialog::OnInitDialog() { HWND hWndCtrl; CWnd pl_wnd; GetDlgItem(IDC_REMOVE_THIS_CHECKBOX, &hWndCtrl); pl_wnd.Attach( hWndCtrl ); pl_wnd.Detach(); pl_wnd.DestroyWindow(); return TRUE; } AVee wrote: > Is it possible to remove a Dialog item from a Dialog at run time? > This code does not work, but I don't know why: > > BOOL CMyDialog::OnInitDialog() > { > HWND hWndCtrl; > CWnd pl_wnd; > > GetDlgItem(IDC_REMOVE_THIS_CHECK...

Export Automatic Completion Cache
Is there any way to export the automatic completion cache of the To: field in Outlook 2002? It would then be re- imported into Outlook 2002 contacts. Yes and no. The cache isn't based on your contacts, it's based on what you type when you send emails. As you enter address in the To: filed the are remembered. So, you could copy the cache from one machine to another if you wanted, but you couldn't import it into Contacts. If you want to copy it from machine to machine, with Outlook closed search your computer for "outlook.nk2" (sans quotes). It's a hidden file, ...

Automatic junking and IMAP in Outlook 2003
My account just got migrated from an POP3 to an IMAP account, and as such the junk email settings doesn't seem to work anymore, Outlook 2003 has stopped moving the junkmail it detects into the Junk E- Mail folder. I've set Outlook to automatically download all messages. Kinda annoying, looking into getting the account moved back as a POP3 account so it works, since I installed 2003, it's caught 99% of all my junkmail. ´┐Żystein it's working here - but I get headers then mark for download and the junk is moved to junk mail on download. -- Diane Poremsky [MVP - Outlook] A...

Move equations from line to line automatically
I need to create a excel template to import information into a MRP system. Specificelly for cabinet doors Pricing is done by the square foot so I need to keep trac of the total price. The problem is the order can be as little as one door or it can be thousands of doors. I would like to see HEIGHT WIDTH STYLE QUANTITY SQ FT PRICE TOTAL So that the total would always appear below the last door entered. I am using Office 2003.Is this possible? You can do it either of two ways: the easy way, or the slig...

graph from an equation
Is there a way in word 2007 to produce a graph from an equation? eg, parabola Create the graph in Excel, then copy/paste it into the Word document (if you really need a Word document). -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Fri, 8 Jan 2010 12:48:01 -0800, Mimi <Mimi@discussions.microsoft.com> wrote: >Is there a way in word 2007 to produce a graph from an equation? eg, parabola You could use Wolfram|Alpha to create the graph, then ...

I have a time sheet but...
I have developed a time sheet. It simply tracks time per day and keeps a running total (in decimal hours) of time over consequtive days. HOWEVER, I would like the following elaborations. I would like to have a list of generalized tasks that I could add to as necessary. .... then be able to enter start and end times with a task that I spent that time on. .... then perhaps on a different sheet show total time, total time for each task, and percent of the total spent on each task. Any thoughts as to how I could proceed or might there be a downloadable example I might modify? Hi Hutch! Good...