Time: None date specific
I am currently creating a music/movie/tv show database.
and for all I track the Time of the track/episode/movie.
As this moment I have to put in 1:30am if I want to indicate the my movie is 90 minutes long. And don't get me started with calculating the album duration based upon the song duration. Apparently my album duration is on a Monday a few hundred years ago?)
-
Allison commented
Could you use integer fields instead and convert to minutes (for movies) or seconds (for song tracks)? This might fix some of the issues you are experiencing with calculations. I don't want to make it seem like this feature shouldn't be implemented, just thinking of other potential workarounds in the meantime! :)