date time field for time

[Souris]

I need a field to store time to spend, like a task takes 5 minutes 20 seconds
to finish, but not hours and minutes like clock time.

I want to 10' 30" plus 5' 25" is 15' 55", but not 15' 55" later.
For example, I have 2 tasks to complete one is 10' 30" and another is 5'
25". I need the sum is 2 tasks take 15' 55", but not get real clock time.

Are there any field to store and calculate the infromaiton?

Is it DateTime field a good choice?

Your information is great appreciated,

 

[Douglas J. Steele]

DateTime is not the appropriate choice: it's intended for timestamps, not
durations.

The recommended approach would be to store the durations as Long Integers
representing total seconds. You might need to write functions to convert
from minutes/seconds to seconds and back again.

 

[Souris]

Thanks millions,

DateTime is not the appropriate choice: it's intended for timestamps, not
durations.

The recommended approach would be to store the durations as Long Integers
representing total seconds. You might need to write functions to convert
from minutes/seconds to seconds and back again.