Charting various times. Help!!

[juxey2000 via AccessMonster.com]

Hi there.

I currently have a table which I have run a query on that tables like this

Date. Target time. Time achieved. Diff.
hh/mm/yyyy hh:mm hh:mm n

I have worked out how to chart the 'Diff' column as this is in number format.
However when I try and throw in the actual times into a chart I get a chart
containing values from 0 through to 0.8??

I have set my format as 'short time' in both the query and the table but to
no avail.

I have searched everywhere and cannot find an answer. All I want is a chart
with the 'target time' as a fixed line and the 'Time achieved' as a timeline
running from left to right. Using the date along the bottom as a reference.

Any ideas??

 

[Clifford Bass via AccessMonster.com]

Hi,

If you are only subtracting the times that would make sense. Try using
the DateDiff() function. Use the following for the difference in minutes:

Diff: DateDiff("n", [Target time], [Time achieved])

Clifford Bass

 

[juxey2000 via AccessMonster.com]

Thanks for the prompt reply but I have already done that in my query and can
produce a chart for the difference between thee two times already. I was just
hoping to ba abke to plot the target verses actual times on a chart as either
two lines or as bars with the time value along the left axis and the date
along the bottom?

I'm assuming the pivot chart is taking my 'times' from the table and
converting them into some sort of numerical format??

Hi,

If you are only subtracting the times that would make sense. Try using
the DateDiff() function. Use the following for the difference in minutes:

Diff: DateDiff("n", [Target time], [Time achieved])

Clifford Bass

Hi there.

[quoted text clipped - 15 lines]

Any ideas??

 

[Clifford Bass via AccessMonster.com]

Hi,

Sorry, I did not read your original question correctly. I am not an
expert on charting. So try this: On the chart property sheet set the Y
axis's (Value Axis 1) number format to be short time. Set a custom scale
from 0 to 1.

Hopefully that will do the trick.

Clifford Bass

 

[juxey2000 via AccessMonster.com]

Clifford you are a legend!!! I knew it was easy because no-one had asked the
question.lol. Back to access school for me!!

Many MANY thanks.

Alan

Hi,

Sorry, I did not read your original question correctly. I am not an
expert on charting. So try this: On the chart property sheet set the Y
axis's (Value Axis 1) number format to be short time. Set a custom scale
from 0 to 1.

Hopefully that will do the trick.

Clifford Bass

Thanks for the prompt reply but I have already done that in my query and can
produce a chart for the difference between thee two times already. I was just

[quoted text clipped - 4 lines]

I'm assuming the pivot chart is taking my 'times' from the table and
converting them into some sort of numerical format??

 

[Clifford Bass via AccessMonster.com]

Hi Alan,

Good to hear it worked. You are welcome!

Clifford Bass