I am working on a custom list inside our sharepoint on-premises 2013. and the custom list will store information about videos and audios (i am not doing to upload the actual audios and videos). and I need a field to store the duration of the video or audio. so not sure which field type best achieve this?
Currently, I define a field named
Duration (in minutes) of type number, and I store the value as following
30 , etc. so is using the Number field type the best option to follow?
The main issue I am currently facing with using the Number field type, is that I cannot express the duration in a user friendly way, such as
01:10:20 which represents
1 hour + 10 minutes + 20 seconds, and I do not want to have a single line text to store the value as
01:10:20 because I will not be able to query the items or sort them according to their duration values (since I will be sorting string values and not actual duration values)...
so can anyone advice on this, please? Thanks