If you are asking how to change the Text representation of a time into a
real time then try:

Copy an unused cell and then highlight the text *times* and then Paste
Special Add. This should turn the text into numbers.

If it does not then there are probably other hidden characters in the cell.
With a *time* in say G3, compare =LEN(G3) with the apparent number of
characters in the cell remembering that a space is still a character. Post
back if you need further help.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Bruce" wrote in message
...
I have a time series that i want to plot where the independant variable is
a
time of day which i think is a text format.

eg. 10:30:31 AM

When I plot this on the x-axis it plots as a cateogry instead on a time,
hence the data points to not have the spacial relation of the time of day.

What do I need to do to plot my dependant variable Y against X which is a
time of day?

Bruce