Think of it this way you want to keep the duration of how long a person
worked separate from when they opened and closed the "task". The reason
being if the person opened the "task" this morning at 9:00am and closed
it tomorrow evening at 5:00pm but only spent a total of 2.25 hrs
actually doing the "task". This separation lends itself to more
flexible reporting.
So with this in mind you want to have a floating integer field and two
date time fields. This way you will always know if a "task" is opened
if the opened data time field is not NULL and the same goes for closed.
I always work with a base of hours and go up and down from there.
This is a little more then you asked but I hope it helps.
Ian
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ian Sheridan
[EMAIL PROTECTED]
http://www.savagevines.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
On May 28, 2004, at 9:49 AM, Jeff Small wrote:
> Okay, so let's say you're using SQL Server, and you want to create an
> application that was going to track time and do things like, eventually
> multiply hours by currency (hourly rate by 1 hour 45 minutes) and add
> several rows containing time to accumulate time spent, time remaining,
> etc,
> and graphing it with CFChart (time spent vs time allocated), etc...
>
> How would you store it and manipulate it in CF?
>
> Do you store it as a DateTime object? What if you only add time on the
> front
> end in fifteen minute increments (say, an "hour"dropdown with "1, 2,
> 3, 4,
> 5, 6, 7, 8" and a "minutes" dropdown menu with "00, 15, 30, 45" so you
> could, say, select "4:45" to insert for your particular time entry) do
> you
> use CF to create ODBC Date Time objects and pass those in, stored as a
> Date
> Time object? But if you enter 4:45, how does it know you're adding a
> *quantity* of time, rather than just saying "4:45 this afternoon"?
>
> So, how *do* you store times if you want to add them and have the math
> work
> right?
> (For example (1:45 + 1:45)$10/hr = $35...like that)
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
