I am developing an application to manage movie data including a record for each Scene. I want to store the Scene Start Time, End Time and Duration so I can do time calculations to calculate Scene Duration. i.e. Scene Duration = Start Time + End Time. Scene Times will be formatted as HH:MM:SS:## for display.
- What Data Type should I use for the Scene Time Fields in the Scene Table?
- What does the Scene Duration calculation code look like?
Scene Start Time 00:10:10:20
Scene End Time 00:15:15:35
Scene Duration 00:25:35:55