FMP 11a, Win XP

I', trying to figure out a neat way to set up the following.

A time tracker utility.

The main goal would be to track the amount of time used per week.
It has to be able log several categories a day and at the end of the week
give a very basic total on each category used.
At the end of the year a total on each category for the year would be nice.

Tables could be:

Years
Weeks
Days

Create a record for the year
create a record for the week belonging to the year
create record for the days within the week

Each day record could hold up to 10 timeslots.
Each having it's own discription
So perhaps I could do with a Timeslot table as well.
The hierarchy being: years > weeks > days > timeslot

But now I want to be able to summarize (or count) the amount of hours spent
within a week on each TimeslotDescription

Day one might look like: [Begin - End Description]
9:00-11:00 DoingA
11:20 -11:55 DoingB
12:00-12:30 DoingC
13:00-14:00 DoingB
etc.

At the end of each week I would like to know to total hours spent within the
week on each Description.

So how do you think I could set this up best.

--
Keep well / Hou je goed

Ursus

"Ursus" <ursus.kirk (AT) ziggo (DOT) nl> wrote

It depends on many other factors (e.g. how you want to use the system /
enter data, what else you want out of it, etc.), but at the simplest level
you really only need one Table with a few data Fields:

Date
Start Time
End Time
Task

plus a Calculation Field to work out the length of time:

Duration = End Time - Start Time

and a Summary Field:

s_Duration Total of Duration

Then simply Find the appropriate Records for the week / month / year, sort
them by the Task Field and print the summary report Layout for the total
time spent on each Task:

TASK DURATION REPORT


[Task] [s_Duration]



or sort them by Date and Start Time and print a summary report for each
Day's work:

DAILY TASK REPORT


[Date]


[Start Time] - [End Time] [Task]




Helpfull Harry )

Thanks Harry,

That's a good place to start from

--
Keep well / Hou je goed

Ursus

"Your Name" <your.name (AT) isp (DOT) com> schreef in bericht
news:i5c0b7$s6a$1 (AT) lust (DOT) ihug.co.nz...