Graphing of times longer than 24 hours

[nickthib]

So I used the thread "Convert number to time" to figure out how to convert, say, 930 to 9:30 in large numbers...

=IF(A1<1000,TIMEVALUE(LEFT(A1,1)&":"&RIGHT(EA1,2)),TIMEVALUE(LEFT(A1,2)&":"&RIGHT(A1,2))).

I plan on using this technique to graph some changing measurements (y-axis) over the period of 2 weeks (ends up being about 13,000 numbers). Unfortunately, when I try to graph anything over 24 hours, the lines loop back to the start of the graph. Any ideas on how to tell Excel that these aren't the same x-values?

I've attached a file to look at if I'm too confusing.

Thanks,

Nick

[shg]

They are overlapping because they are the same numbers.

Dates and times in Excel are just numbers. The whole part fo the number is the number of elapsed days since Jan 0 1900; so 03 Feb 2009 is 39,847.

The decimal part is time; so 39,847.75 is 18:00 03 Feb 2009.

So add a date component to the numbers -- either the actual calendar data or just days elapsed since data acquisition began.

Then you can format the times as [hh]:mm to see total hours.