We help IT Professionals succeed at work.

MS Access Question Chart

Hiroyuki Tamura
on
72 Views
Last Modified: 2017-12-06
I need to create a chart Y: minutes .
I have a time field. How do I convert data and use for Chart?
Comment
Watch Question

CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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.
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
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)
Hiroyuki TamuraField Engineer

Author

Commented:
Thank you
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.