Total Sum Of Time Per Week

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

Guest

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?
 
Date/Time fields store a point in time. For instance, if you enter 8:00 AM,
you are actually storing 12/30/1899 8:00. Your value of "29.2590277777778"
returns 1/28/1900 6:13.

To convert this number to hours, divide by 24 since there are 24 hours in a
day. For more information on displaying date/time values, check Doug
Steele's page http://members.rogers.com/douglas.j.steele/Diff2Dates.html
 
If I need to add those diff2dates duration together? Do I just sum them using
"+" or some other syntax to do that?
 
Okie...I go try it first. ^_^

Duane Hookom said:
Use something like
Diff2Dates("hn", 0,Sum([WorkingTime]))


--
Duane Hookom
MS Access MVP


Seikyo said:
If I need to add those diff2dates duration together? Do I just sum them
using
"+" or some other syntax to do that?
Click to expand...
Click to expand...
 
Back
Top