Re: Format a field for Time, but as duration?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Why not use a Start and End field? People fudge less if they have to enter
the two times.

"Matt D Francis" wrote:

> 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
>
> "Allen Browne" wrote:
>
> > See:
> > Calculating elapsed time
> > at:
> > http://allenbrowne.com/casu-13.html
> >
> > The article suggests that the Number field is the best format, and explains
> > how to use Mod, integer division, and the Format() function to display the
> > result as hours:minutes.
> >
> > --
> > Allen Browne - Microsoft MVP. Perth, Western Australia.
> > Tips for Access users - http://allenbrowne.com/tips.html
> > Reply to group, rather than allenbrowne at mvps dot org.
> >
> > "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?
> >
> >
> >
.

Relevant Pages

  • Re: Format a field for Time, but as duration?
    ... > The article suggests that the Number field is the best format, ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Format a field for Time, but as duration?
    ... Calculating elapsed time ... The article suggests that the Number field is the best format, ... how to use Mod, integer division, and the Formatfunction to display the ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Calculating elapsed time problem
    ... Matt Wills wrote: ... > With fields named TStampBegin, TStampEnd and Format in place the CF ... > "Hours", ElapsedSeconds is divided by 60, and there's your answer. ...
    (comp.databases.filemaker)
  • Re: is mapping a floppy drive possible in win2k server?
    ... You can't format a mapped drive. ... Ok, Matt, here's the update: ... > prompting to format the drive first, and then write the data to floppy. ... >>walk to the server and create the floppies from the 'a' drive. ...
    (microsoft.public.windows.server.general)
  • Re: Excel Timesheet
    ... Matt Wrote: ... >> Just subtract the lower from the higher, and format that cell as time ... >> then just add the two totals cells together, ... Try formatting the cell as:mm ...
    (microsoft.public.excel.misc)