View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Charting Time Samples

What do you want to learn when you look at the chart?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Flip wrote:

I have a spread sheet with a time value in hours:minutes:seconds in
column A and another on column B with a value in hours:minutes:seconds.
In column C is the difference betwen the two. (=TEXT(B1-A1,"h:mm:ss")
with a results like this....
0:00:48
0:00:48
0:00:48
0:00:48
0:00:50
0:00:48
0:00:50
0:00:52
0:00:52
0:00:57
0:00:58
0:00:58
0:00:58
0:00:58
0:00:58
0:01:00
0:01:00
0:01:00
0:01:00
0:01:00
0:01:00
0:01:00
0:01:02
0:01:02
0:00:04
0:00:04
0:00:04
0:00:04
0:00:06
0:00:06
0:00:06
0:00:06
0:00:06
0:00:06
0:00:06
0:00:25
0:00:25
0:00:25
0:03:25
0:00:27

How do I chart these time samples?