counting with dates and hours in a form

[pascal]

I have a form based on one table. On the form I have 4 fields ("DateIn", "HourIn", "DateOut", "HourOut"). Now, I want to make a new textfield (not bound) on the form which has to show me how many hours are between DateIn HourIn and DateOut HourOut. Can someone help me please as quickly as possible because I already need it by tomorrow.

Thanks in advance guys.

 

[pascal]

I'm gonna give an example. How many hours and minutes are there between for example 01/01/2002, 08:00 and 05/01/2002, 14:00. Can you calculate this in an expression? If so, what is it. Can someone help me out here?

Thanks.

 

[DJN]

There is a very comprehensive article on calculating time on the Microsoft Knowledge Base.

http://support.microsoft.com/default.aspx?scid=kb;en-us;q88657

David

 

[pascal]

Thanks David,

I think this is what I was looking for.