View Single Post
  #2   Report Post  
Steve=True Steve=True is offline
Junior Member
 
Posts: 12
Default

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