Determine Hours/Minutes

  • Thread starter Thread starter Jan
  • Start date Start date
J

Jan

I have a gate log where hours need to be tracked. The
table has a TimeIn field and a TimeOut field. If someone
clocks in at 6:45a and clocks out at 15:30p, the total
time needs to reflect 7 hours and 45 minutes.

Using "h" in DateDiff only displays the hour and not the
minutes. Is there a way to capture both?

Thank you...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Calculated minus breaks & lunch 2
Calculating hours on a timeclock form 7
Time Conversions 2
Calculating Meal Period Violations in Access 2
Formatting Result of Date AND Time Difference 3
Daily Time Sheets with Rounding 1
#Error in calculated field of Datasheet view of query 2
Access DateDiff function 0

Back
Top