Change a date time field display from hours to minutes

[Geoff]

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.

 

[Douglas J. Steele]

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.