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...
 
Back
Top