Link to home
Start Free TrialLog in
Avatar of Hiroyuki Tamura
Hiroyuki TamuraFlag for United States of America

asked on

MS Access Question Chart

I need to create a chart Y: minutes .
I have a time field. How do I convert data and use for Chart?
Avatar of PatHartman
PatHartman
Flag of United States of America image

The Datetime data type represents a point in time on a specific date.  It should not be used to store elapsed time.  I don't really understand your question so please give us more information.
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If the time part of the field is  2:24 which would be a point in time, you get 24 as the minutes value.  If you are using this as elapsed time, you will want 120 + 24 so that would make the expression:

(Hour(YourDate) * 60) + Minute(YourDate)

If the field accumulates more than 24 hours, then you need to convert the "days" also
But a Pat requested ...we still need to know a lot more about your data, ...and the format of the chart.

Please post an example/sample of your data, and also post a clear graphical example of the output you are looking for (based on the sample data)
Avatar of Hiroyuki Tamura

ASKER

Thank you