date time field for time

  • Thread starter Thread starter Souris
  • Start date Start date
S

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,
 
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.
 
Thanks millions,


Douglas J. Steele said:
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.
Click to expand...
 
Back
Top