Search results for query: *

That is what I was looking for. I tried =DateDiff("n",DateIn, DateOut)/1440 and the hours were correctly calculated with short time format, but it would not account for the difference in days. I then tried all kinds of preset time formats, along with a couple of make-shift ones that I came up...

Sorry about being a little vague. It is a sign-in/sign-out sheet, and the times can be greater than 24 hours with different dates. Here is some of the sample data: userid site dateout datein hours xxx xx 06/29/04 6:00 AM 07/01/04 5:00 PM...

Thanks for the simplification. I am now getting the displayed time, except it is incorrect. Does the DateDiff function account for differences between days, and AM/PM? Could field formatting cause it to be off? Any ideas on the miss calcuation? Thanks

Ok, forgive this basic quesion. I changed the timein/timeout fields to the correct ones that I have, but how do I display the results? Is datediff a built in function? Again, the expression builder is not my strong point. TIA

I have not worked in Access for quite some time, but here is what I am attempting to do. I have two date/time fields that I need to subtract for each user ID and then total them for a specific site. Example: userid location date/time_out - date/time_in =(need hours) xxxxx xxx...