cell format as time from 0

[Tom_B]

I have a list of variables which I wish to chart over time. The data was recorded by third party software and and saved in CSV format with a time base starting at time 0 and plotting every second. When I try to format the time cells it produces dates referenced to 1900.

Anyone know how to format as time but reference to second 0 and count up.

Some of the data as an example. I'm not sure how the first column numbers were generated but each entry is approx +1 second from the previous.

0.0242 - 4.5999
0.0408 - 4.6
0.0577 - 4.5999
0.0744 - 4.5959
0.091 - 4.591
0.1076 - 4.5866
0.1243 - 4.5907
0.1425 - 4.5868
0.1591 - 4.5907
0.1758 - 4.5822
0.1926 - 4.5871
0.2093 - 4.5782
0.2259 - 4.5615
0.2428 - 4.5619

[NigelFrost]

It seems the recordings are taken in minutes. It might be easier to convert the readings to seconds first (multiply by 60) in a separate column and then using the TIME Function. Or you can do it all in one go with the formula "=TIME(0,0,A1*60)" where A1 is the column 1 reading. Make sure you then format the cells to display a custom format hh:mm:ss (or whatever other format you would like)

[FDibbins]

What does the data look like when it come in from the other software? Are there any import options?

Perhaps a sample file will help to show what you have, and maybe you can add a few samples of what you want?

[Tom_B]

These are just a sample of the first records and there are actually over 1600 records from a period of 27 mins.

The data is as you see it or as a jpg, that's it.