Re: Format a field for Time, but as duration?
- From: "Jeff Boyce" <nonsense@xxxxxxxxxxxx>
- Date: Mon, 20 Jun 2005 08:52:19 -0700
Matt
Access offers the Date/Time datatype, which ONLY stores point-in-time data.
To handle hours & minutes (and seconds and ...), you'll have to "roll your
own". You can use a combination of fields ([HoursField], [MinutesField],
....) and/or you can use a "lowest unit of measure" approach ("enter the
total number of minutes") and parse it into hours/etc. for display purposes.
Check the mvps.org/access website for additional ideas.
Good luck
Jeff Boyce
<Access MVP>
"Matt D Francis" <MattDFrancis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:363FD88E-44CC-444F-B989-418971176DB2@xxxxxxxxxxxxxxxx
> Hi,
>
> I have a field in a table where users enter the time a task took. This is
> entered in minutes, such as 90 minutes (1hr 30mins)
>
> The field is currently a Number field which works but I can see that will
> cause problems when we come to analyse the data and need to total the
> hours
> and minutes.
>
> What is the best way to format the field in the tabel so that the data
> will
> actually be held in hours and minutes (but not time of day) and can
> therefore
> be used to summarise without adding calculations to it?
.
- References:
- Format a field for Time, but as duration?
- From: Matt D Francis
- Format a field for Time, but as duration?
- Prev by Date: Re: Connecting a Check Box with a date Field?
- Next by Date: Re: Update query with a Sum()
- Previous by thread: Format a field for Time, but as duration?
- Next by thread: Re: Format a field for Time, but as duration?
- Index(es):
Relevant Pages
|
