Charting time consumption

  • Thread starter Thread starter Espen Rostad
  • Start date Start date
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?
 
Format Column C to the below and try
[h]:mm:ss
(Right click>Format Cells>Custom Format)
 
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
 
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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

arrived in appt time 1
Calculate the amount of time over a permitted amount (12 hours) 7
Subtract times? 2
Excel Format Question -- CC:SS treated as time HH:mm 2
Subtracting Date/Time 4
Highlight a cell if time for task is over one hour 3
format time problem 5
Time - Analysis based on time 3

Back
Top