What format to use for time values (hh:mm:ss) for CD song lengths.

M

Mike Ramsdell

What format to use for time values (hh:mm:ss) for CD song lengths, so total
time can be calculated in a form or report.
 
K

Ken Snell [MVP]

I would use a Long Integer field, and store the actual number of seconds for
the song length. You then can use calculations to convert to
hours/minutes/seconds, and to calculate total times.
 
D

Douglas J. Steele

Unless you've got more than 24 hours worth of songs that you're reporting,
you could probably get away with simply using a Date field, and storing just
the time in there. Recognize, though, that that's not really the point of a
Date field: it's intended to store a timestamp (date and time).

The normal recommendation is to store the time in a Long Integer as a total
number of seconds. Write your own function to convert back and forth between
seconds and hh:mm:ss.
 
Top