datediff for number of minutes between two times that falls on different dates

[YoBi4Ever]

Dear,

I am using datediff function to get the number of miunutes between to times: Me.WorkedMinutes = DateDiff("n", [OTIn], [OTOut]) and it works oK EXCEPT when I'm computing the minutes between two times that falls in different days. for exmaple number of minutes or hours worked betwen 24.02.2013 from 16:09 to 25.02.2013 00:03 then i get -966!!

Can someone please let me know how to workaround this issue?
Thank you.

 

[PHV]

I get 474 with your posted DateTime values ...

 

[strongm]

Me too

 

[YoBi4Ever]

I checked and I got -966.
Maybe it is checking between 16:06 on the 24th and 00:03 on the 24th as well!
I tried to attach screen shot but i didn't know how.

Thanks for all your help.

 

[MajP]

I am curious to the actual values. Can you somehow print the real values such as?
Debug.Print Format(OTin, "General Date")
Debug.Print Format(OTout, "General Date")