DorisH3 at aol.com
DorisH3 at aol.com
Mon Dec 4 22:00:47 CST 2006
I have a table that maintains the Volunteer Number, Time In, Time Out, Date
Worked. I have put together a report using a query that shows the volunteers
name, volunteer number, date worked, time in, time out. On the report I
show all of the fields that are contained in the query along with a calculation
TimeOut - TimeIn which I named Hours. My report looks like this
Name Vol# Date TimeIn TimeOut
Hours
Alice White 1099
10/1/06 4:00 PM 7:00 PM
3
10/5/06 4:00 PM 7:00 PM
3
10/7/06 4:00 PM 7:00 PM 3
10/10/06 4:00 PM 7:00 PM
3
In the group footer I did a calculation as follows =Sum([Hours]) and in the
report footer I did the same.
It appears that anything under 24 hours calculates OK, anything over 24
hours is incorrect....can anyone help me...I am a novice at this so I apologize
ahead of time.
Doris