Re: How do I add times beyond 24 hours in Access?

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Wed, 15 Mar 2006 16:01:27 -0800, DavidDonaldDoo
<DavidDonaldDoo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I need to create a database that can add hours worked in an [hh:mm] format
that can surpass 24 hours. I do not know which format to choose when setting
up the field.

Thanks

You can't.

Access Date/Time values don't have a format that does this, and
they're really not suitable for storing durations. I'd suggest storing
the duration in a Long Integer field storing minutes (e.g. 25 hours =
1500) and displaying the results with an expression like

[Duration] \ 60 & Format([Duration] MOD 60, ":00")

John W. Vinson[MVP]
.

Relevant Pages

  • Re: Adding hours
    ... Your basic issue is that you may be storing durations of time in a field ... > format does not work in the format of a sum in Access ...
    (microsoft.public.access.reports)
  • ZPack update
    ... of note, a few additions have been made to the format, in particular: ... building an indexing structure and storing it to disk may make sense. ... index structure at load time, which may make the most sense for directories ... nature of the format (most implementations of b-trees I have seen have been ...
    (comp.compression)
  • Re: Standards question on edited fields
    ... > Who said I was storing it? ... and it seems you would not present such a format to ... it's not a sloppy design at all - and there is a valid reason. ... Judson McClendon ...
    (comp.lang.cobol)
  • Re: 2D height map to 3D model?
    ... (you're storing 12 doubles for almost every data-point). ... If you have a format that allows for triangle/quadrilateral strips, ... can make the rendering far more efficient using them. ...
    (comp.lang.python)
  • Re: Format Table data type for time
    ... Access Date/Time fields don't really lend themselves to storing durations; ... You can display it in n:ss.ss format using an expression like ...
    (microsoft.public.access.tablesdbdesign)