Determine Hours/Minutes

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

Top