[AccessD] Recording Time

Thanks Gustav & Mark for your replies:

Gustav, what field data type are you using to store the time data?

Thanks! 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, June 02, 2006 10:25 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Recording Time

Hi Larry

We use both, or rather: a decimal duration, a start time, and a stop time -
which match and update each other, quite fancy.
Format of time fields is hh:nn, and InputMask is 90:00,1,0 - and a lot of
code to allow for navigation and clicking inside the time fields and
filtering for invalid keytypings.

It takes a lot of testing but users like it.

/gustav

>>> lmrazek at lcm-res.com 02-06-2006 16:48:24 >>>
 
Hi Folks:

I have an app that tracks time spent on various activities (production,
cleaning, etc.). 

I'd appreciate some opinions on the best ways to record the time spent.
Basically, we're looking at hours and minutes spent, usually something like
four hours, 15 minutes. I considered having the app record the time as: 4.25
(4 hrs 15 minutes), but this approach seems to confuse some of the users. 

Another approach would be to use two text boxes to collect hours and
minutes, then convert and store the data as minutes. (I could use a display
format to convert the minutes into something like: 4:15). 

Any ideas on best practices for storing this type of data?

Thanks in advance!

Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314.432.5886
fx. 314.432.3304


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com