| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting Time Samples
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time sheets | Excel Worksheet Functions | |||
| Formula for a time card | Excel Worksheet Functions | |||
| Charting Run Times | Charts and Charting in Excel | |||
| Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
| Charting time? help please... | Charts and Charting in Excel | |||
Threaded Mode
