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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working Time calculation - from text to short time 2
Date/time field changing seconds to all zeros 3
How to SELECT with date criteria by SQL? 1
conversion of seconds to other formats in MSAccess 3
Shortcut for current Time in hh:mm:ss 2
query times 2
Excel Calculating Phone bill per second 6
Storing a date in UK format 17

Back
Top