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?
Hiroyuki TamuraField EngineerAsked:
Who is Participating?
Gustav BrockConnect With a Mentor CIOCommented:
If you data are of data type Date, then minutes are extracted easily:


Open in new window

or, if it is a count of minutes from zero (Midnight):

=DateDiff("n", #00:00#, [YourFieldName])

Open in new window

To exclude a date part from your values:

=DateDiff("n", #00:00#, TimeValue([YourFieldName]))

Open in new window

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.
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 LiasonCommented:
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 EngineerAuthor Commented:
Thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.