Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Plotting Performance Logs - time format question.

Status
Not open for further replies.

stduc

Programmer
Nov 26, 2002
1,903
GB
If I set up performance counters to save to a .csv file then I get a time column entitled.
"(PDH-CSV 4.0) (GMT Daylight Time)(-60)"

What does this mean? Especially that (-60)!

If I format the column to dd/mm/yy hh:mm:ss it still insists on giving me month day year! Or at least it seems that way.

I want to format the time column to show the real time the data point was made.

I realize that I can import the csv file as text and write a formula to do the job, but is there an easier way?

[navy]When I married "Miss Right" I didn't realise her first name was 'always'. LOL[/navy]
 
What does it look like if you open the csv in a text editor rather than excel ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 




Hi,

"If I set up performance counters to save ..."

Saveing

1. FROM what application?

2. by what method?

Skip,

[glasses] To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top