LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time sheets Driver Excel Worksheet Functions 5 November 7th 05 11:19 AM
Formula for a time card skateblade Excel Worksheet Functions 6 November 2nd 05 09:28 PM
Charting Run Times Nick Junod Charts and Charting in Excel 3 October 31st 05 02:37 AM
Time Sheet Calculation Help Needed! sax30 Excel Worksheet Functions 2 April 26th 05 08:08 PM
Charting time? help please... Gustavo Monteverde Charts and Charting in Excel 1 November 28th 04 04:53 AM


All times are GMT +1. The time now is 10:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"