Bokscrock said:
I would like to be able to input time open and time closed
on a daily record, then determine total hours per day
(hours:minutes), and on a monthly report, total number of
hours:minutes, this may be repeated for tasks during the day,
for example training, etc and each will then be totalled and
finally calculated to man hour effeciency
Admirable requirements. This can certainly be done with Microsoft Access.
What, specifically, is your question?
Newsgroups are very good sources for practical answers to specific, detailed
questions; they are not good sources for general tutorials on building a
particular type or genre of application.
If you are just starting, the first thing you need to do is clearly define
the information you need, the source(s) of that information, and how you can
transfer that information from the source to your database. You don't
mention whether you need the time _by person_ or whether you are just
lumping together everybody's time... that is, do you want to calculate the
efficiency of each person or of the entire force of workers.
And, if you are just starting the application, chances are that you will
consider the information output (reports and forms) but that you have a good
deal of work to do before you design / implement a report.
Here are a few general hints for the kinds of calculations you describe
which will apply regardless of the details:
(1) Date/time is a field or variable type representing a point in time...
that is a date and time. It is not intended and is not generally useful for
keeping and calculating elapsed time.
(2) Elapsed time between two date/times is calculated using the DateDiff
functionl. Open any module window and look it up in Help.
(3) My guess is that you will want to keep your elapsed times in minutes
(rounded to whole minutes), minutes with fractional part, seconds, or
minutes and seconds. In the first case, Long Integer would be an
appropriate data type, in the second, either Single or Double-precision
Floating Point; in the third, either Long Integer or Single- or
Double-precision Floating Point; in the last separate fields for each, which
might be Long Integer or Single- or Double-precision Floating Point. In your
calculations, you will have to determine the form in which you want to
present your answer.
Larry Linson
Microsoft Access MVP
