conversion to time

M

Martijn

Problem concerning the conversion of the following.

Table input is as follows:

Delay //Input time as a number with inputmask
01:23 00:00;0;_
00:23
00:14

I need a conversion so that in the report the average time
is displayed as 00:53 hours.
I have the following: When is display the total time, the
total time is displayed as 53.333.

How do I tell Access that the input is a time input?

Thanx Martijn

[email protected]
 
Top