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?

Format Column C to the below and try
[h]:mm:ss
(Right clickFormat CellsCustom Format)
--
If this post helps click Yes
---------------
Jacob Skaria


"Espen Rostad" wrote:

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?

I'm sorry to say Jacob, that did not work

Jacob Skaria skrev:

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

"Espen Rostad" wrote:

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?

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:

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:

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

Espen Rostad skrev: