Time difference calculated wrong

[skwilliams]

I have two fields a timein and timeout field within my table. Both fields are in hh:nn:ss format. I need to calculate the time difference into a unbound field on a report, but the time difference is wrong. Here's an example:

TimeIn=13:45:06
TimeOut = 13:45:18

Using the calculation =([TimeOut]-[TimeIn]), I receive the following result.

TimeDiff=23:59:48 instead of 00:00:12.

I'm confused!

 

[sfreeman@co.mer]

This works for me:

SELECT
[TimeOut]-[TimeIn] AS TimeDiff

FROM
tblDate;