Formula

  • Thread starter Thread starter Loi
  • Start date Start date
L

Loi

Hi,
I have a table which has CHECKINTIME and CHECKOUTTIME
fields. May I create a query that will show TotalTime
check out?

For example:
CheckOutDate CheckOutTime CheckInDate CheckInTime
10/21/04 8:30 am 10/22/04 10:30am.

Total time that I counted out by myself is 26 hours or 1
day 2 hours.

Please show me how to create query which shows a TOTALTIME.

Thank you very much
LOI
 
Hi,
I have a table which has CHECKINTIME and CHECKOUTTIME
fields. May I create a query that will show TotalTime
check out?

For example:
CheckOutDate CheckOutTime CheckInDate CheckInTime
10/21/04 8:30 am 10/22/04 10:30am.

Total time that I counted out by myself is 26 hours or 1
day 2 hours.

Please show me how to create query which shows a TOTALTIME.
Click to expand...

Put

DateDiff("h", [CheckInDate] + [CheckInTime], [CheckOutDate] +
[CheckOutTime])

in a vacant Field cell in a query.

Note that an Access Date/Time field is stored internally as a Double
Float count of days and fractions of a day (times) since an arbitrary
start point; as such it's usually better to use a single date/time
field (CheckInDateTime say) rather than separate date and time fields.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top