Total Sum Of Time Per Week

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

From: Seikyo (Seikyo_at_discussions.microsoft.com)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 00:07:05 -0800

How do I display the total time per day for a group of people's TimeCard? I
did a queries to add the working time (Date/Time Field) together for all the
people which turn up to be "29.2590277777778" in numeric. Is that the actual
time? Is it I just add the time together in Date And Time Field? For
example, #8:00# + #8:00# + #12:00#.....

How can I convert to hours and minute? I do it in the report? or in queries? 

-- 
Seikyo

Relevant Pages

  • Re: First of and last of help!
    ... >the totals in queries (despite having done a search in this group and ... the physical order of records gets rearranged if you ... retrieve an arbitrary record's value, ... date/time field in the table and use a query searching for the maximum ...
    (microsoft.public.access.queries)
  • Re: Soft Delete Records (to an archive)
    ... The simplest way to do this is not to bother. ... Instead, just add to the table a Date/Time field called DateDeleted, ... with a defalt value of NULL. ... Modify the queries behind your forms etc. ...
    (microsoft.public.access.formscoding)
  • Re: Date issue
    ... Microsoft Office/Access MVP ... queries there is a date/time field. ... In a different query the user will enter a begin ... database list the date/time field as 01/01/2008 access list it as ...
    (microsoft.public.access.queries)