Format a field for Time, but as duration?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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>
 
Thanks guys - was hoping for a "easy just click on X" type answer but this
will do! I will check them out, thank-you

Matt
 
Back
Top