Graphic Posted March 7, 2006 Share Posted March 7, 2006 hi if i export a logging file in .txt or .xls it doesn't show the time i should. now i read if i export my time in excel time i could format the culomn to date/time to show the time. one problem. i don't know how to do that. does anybody have an idea on how i could get the correct time in excel or wordpad. thnx Link to comment Share on other sites More sharing options...
AzeoTech Posted March 7, 2006 Share Posted March 7, 2006 In Excel: Just select the column (by clicking on the column header), then go to Cells-Format and select your desired date/time format. Link to comment Share on other sites More sharing options...
Graphic Posted March 7, 2006 Author Share Posted March 7, 2006 nope doesn't work with me anyways. keep getting stuff like 38783.56801 1.708984 2.179921 38783.56803 1.708984 2.288365 38783.56804 1.713867 2.401709 38783.56805 1.708984 2.518124 38783.56806 1.708984 2.627637 38783.56807 1.713867 2.743295 38783.56808 1.708984 2.852709 with the first column being the time Link to comment Share on other sites More sharing options...
AzeoTech Posted March 7, 2006 Share Posted March 7, 2006 I'm not sure what you are doing wrong. Do the three columns end up in different columns (different cells) in Excel? If not, then you are importing it wrong (perhaps selecting tab delimited instead of comma). I attached a sample showing it working. I simply typed in the first two rows of numbers you posted and then clicked on the column header for A (which highlighted the whole column) and selected Format-Cells, then picked Date from category and one of the date types. Link to comment Share on other sites More sharing options...
Graphic Posted March 8, 2006 Author Share Posted March 8, 2006 thanx i made a new loggingset. think that dit the trick. but the file is read-only. i'm not allowed to modify it. i there i way i can? Link to comment Share on other sites More sharing options...
AzeoTech Posted March 8, 2006 Share Posted March 8, 2006 You can't modify it while DAQFactory is using it. So you either need to quit DAQFactory, or set the logging set file to a different file so DAQFactory releases the file. DAQFactory can't let you open it while it is editing for optimization reasons. Link to comment Share on other sites More sharing options...
tania Posted January 29, 2008 Share Posted January 29, 2008 i too undergo the same problem of the data i.e.my time and ecgvalue clubbing together in one coloumn i tried to change th format but it dosnt bring any changes.... is there sumtg i can do from the sequence side or event side..to bring a chnge in the data display??? thnk you my version is 5.15 Daqfactory Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.