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

(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top