Plotting Performance Logs - time format question.

[stduc]

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]

 

[xlbo]

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

 

[SkipVought]

Hi,

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

Saveing

1. FROM what application?

2. by what method?

Skip,

_{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]}