How to get the Difference Between Two Time Fields?

[pravipravi]

Actually i am using two time values.But they are created as Date and time format.Keeping that format i want to find the Time deffrence between InTime and OutTime.As do the job normally i got a 0.30658874 as answer.How can i make the diffrence?That is Outtime-InTime form tblHistory?

[MMcCarthy]

Actually i am using two time values.But they are created as Date and time format.Keeping that format i want to find the Time deffrence between InTime and OutTime.As do the job normally i got a 0.30658874 as answer.How can i make the diffrence?That is Outtime-InTime form tblHistory?

TimeSerial(0,DateDiff("n",[InTime],[OutTime]),0)

Try this.

Mary

[MSeda]

multiply by 24. Even though the format only shows time it's still calculated as time and date.

[NeoPa]

As MSeda says, the result you got is actually quite correct and refers to a fractional portion of a day. To get the days from this use :

Format(OutTime - InTime, "0")

To get the fractional portion use :

Format(OutTime - InTime, "HH:nn:ss")