Hello,
To do this, i would do the following:
If your first time was in A1 and your second time was in B1
Then in Cell C1 I would type in this fomula
=TEXT(A1,"hh:mm:ss")&" to "&TEXT(B1,"hh:mm:ss")
Then create your chart.
Add a chart Horizontal Axis title.
Then click on the Horizontal Axis title.
Then type in the equals sign (=)
Then Select cell C1
Let me know if this help.
Steve=True
|