2nd Post Time Difference

[Bryan Hughes]

Hello,

I am trying to figure out the difference between two time values.

The values are entered in medium time format.

8:00 AM and 10:15 AM but every time the value returned is 2.

Here is how I have it set up.

dtmTimeIn = Format(#8:00 AM#, "Medium Time")
dtmTimeOut = Format(#10:15 AM#, "Medium Time")

If IsDate(dtmTimeIn) And IsDate(dtmTimeOut) Then
intTime = DateDiff("n", dtmTimeIn, dtmTimeOut) / 60
Else
Exit Sub
End If

Me.txtD1Hours.Value = intTime

Why is this only returning 2? What am I missing?

-TFTH
Bryan

 

[Paul Overway]

You are trying to use an integer to hold a fraction. Use datetime or
double.

 

[Douglas J. Steele]

Let's hope he sees your answer, Paul, since he obviously didn't see the
response I'd posted about an hour before he reposted this question!