Change a date time field display from hours to minutes

I am designing a database which a field displaying the duration of an action
is required in Minutes and Seconds. However the date time field properties
are shown in hours and minutes, the maximum being 23.59. I need to display a
reading greater than this.
Can I change the format of the date time field to show the figures I require.

The Date data type is intended to store a timestamp (a point in time), not a
duration.

The usual advice is to determine what resolution you need for your durations
(eg. seconds, minutes, etc.), and store the duration as a Long Integer
representing that number of units. You can write functions to convert
between the Long Integer representation and the hh:nn:ss representation.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Geoff" wrote in message
...
I am designing a database which a field displaying the duration of an
action
is required in Minutes and Seconds. However the date time field
properties
are shown in hours and minutes, the maximum being 23.59. I need to
display a
reading greater than this.
Can I change the format of the date time field to show the figures I
require.