Help!!! Calculating times in a database

[Ean James]

Hi,

I need to calculate to times in a data base

Table: Times

leaving time 07:30

Interval 02:30

I did this calculation in a query: Time: [Times]![leaving time] - [Times]![Interval]

Both fields are in SHORT TIME

When I run the query I get: Time = 0.208333333333333

What am I doing wrong????

Please help!

Thanks

Ean James

 

[Smee]

I'm sure someone will be along with a better answer than mine, but as I remember it you need something along the lines of:

Time: (vb_short)[Times]![leaving time] - [Times]![Interval]

That looks wrong, but I think you need to cast the result to type Short Time somehow.

Apologies for my ramblings

 

[Ean James]

Thanks

What does the (vb_short) stand for then, will that have to be included in the expresion or will something need to be in its place, I have looked it up as much as I can but it only talks about date and how to calculate them

Thanks again

Ean James