Total short time fields in query

I'm working on a project that was dropped in my lap. It is in Access
2003. There are short time fields which get calculated values (eg.
1:30). But I will need to total up those values for reports in
qiueries. When I tried to drop one of the fields in the query builder
and used the total function the totals was way off.
>
So I was wondering what would be the best way to do this? Thanks in
advance for the help.

I think generally that you do not want to total times. *What would the total
of 18:00 and 14:30 and 4:00 mean or be useful for? *Perhaps the result of
subtracting one time from another, yielding elapsed times can be added
usefully?
>
Regards
>
Kevin
>
"Ecohouse" <ecovinda...@yahoo.comwrote in message
>
news:3476a795-6e48-4aad-8f80-c34a494b6d3b@k37g2000hsf.googlegroups.com...
>
>
>>>
- Show quoted text -

I'm working on a project that was dropped in my lap. It is in Access
2003. There are short time fields which get calculated values (eg.
1:30). But I will need to total up those values for reports in
qiueries. When I tried to drop one of the fields in the query builder
and used the total function the totals was way off.
>
So I was wondering what would be the best way to do this? Thanks in
advance for the help.

"Ecohouse" <ecovinda...@yahoo.comwrote in message
>
news:3476a795-6e48-4aad-8f80-c34a494b6d3b@k37g2000hsf.googlegroups.com...
>>>
I'm confused, when you say "there are short time fields" do you mean a field
containing values like 3:30pm, 4:00pm, 12:14am, etc? Or do you mean a field
containing values of elapsed time like 1.20 secs, 5.50 hrs, etc. The former
is formatted as date/time, the latter is a number. A summation of the former
doesn't make sense, but the summation of the latter does.
Fred Zuckerman

I'm working on a project that was dropped in my lap. It is in Access
2003. There are short time fields which get calculated values (eg.
1:30). But I will need to total up those values for reports in
qiueries. When I tried to drop one of the fields in the query builder
and used the total function the totals was way off.
>
So I was wondering what would be the best way to do this? Thanks in
advance for the help.

A field would have the value of 1:30. This would represent one
hour and thirty minutes. I didn't set this up and now I'm stuck
with it and trying to figure out a way to deal with this.
>
So I have to create reports where I will be grouping departments
and I need the total hours and minutes. I'm trying to do this
using the query builder. Any ideas?
>

On May 5, 4:25*am, "Fred Zuckerman" <Zuckerm...@sbcglobal.net>
wrote:

>lddrer>
>

Ecohouse <ecovinda...@yahoo.comwrote in
news:3d824645-d110-47a3-958d-170c4afa394a@
24g2000hsh.googlegroups.com
:
>>>
So you are talking of durations and not times. Access stores the
date and time as the number of dats since Dec 31, 1899 and the
fraction of the day reresents the time. e.g. noon is 0,5, 6:00 pm is
0.75.
>
So first you need to determine if there is a hidden date in the
field, then subtract that from the shown value, and total the
fractions, then redisplay as as a duration.
>
If instead the time is stored in a text field, not date-time, you
will need to write a function in Visual basic code to split the
parts into a fraction of a day, then sum and reformat as a duration.
>
until anyone can give you specific instructions, we'll need to know
1) the field type (open the table in design mode),
2) the field format,
3) if a datetime field, whether the dates are all 12-31-1899 or
various recent dates, build a query and format the field as general
date.
>
Q
>>>
c34a494b6...@k37g2000hsf.googlegroups
>
>
>
>
>>>>>>
--
Bob Quintal
>
PA is y I've altered my email address.
** Posted fromhttp://www.teranews.com**- Hide quoted text -
>
- Show quoted text -