Charting time consumption

E

Espen Rostad

Yet another problem from a confused norwegian..

Column A contains time of start (hh:mm)
Column B contains end time (hh:mm)
Column C contains consumed time B-A (hh:mm)

I want to draw a chart illustrating consumed time, but this only appears as
a mess when i try to chart it.. Any ideas?
 
J

Jacob Skaria

Format Column C to the below and try
[h]:mm:ss
(Right click>Format Cells>Custom Format)
 
E

Eduardo

Hi,
If you have all your columns format as time, in excel 2007 do , Insert,
select the graphic you want, I have choosen column, the three columns come up
to the chart, then right click in the chart on top of the start time, delete,
do the same with the end time, so now in the chart is only the consumed time
 
E

Espen Rostad

Start and end time comes out fine, but consumed time don't make any chart..
Btw I use Excel 2003. Thanks anyways for trying

Eduardo skrev:
 
E

Espen Rostad

I woluld also like 00:00 values (as whne there is no start- and end time) to
return as empty cells. I'm not able to figure out how to format this

Espen Rostad skrev:
 
E

Espen Rostad

By means of earlier postings I managed to solve my two problems.

Espen Rostad skrev:
 
Top