I am using the stopwatch component to measure baseball player run times. After stopping the watch, i want to save the time to a collection and be able to calculate fastest and average time.
I cannot figure out the correct format to save the stopwatch time data. The default formats for time in my collection do not accommodate the MM:SS.MS stopwatch format…when i update or create a record using the component [time(miliseconds)] the time saves to my collection as date and hour, not the stopwatch time i expected.
i tried number and text formats. with number i lose the minute/second/millisecond distinction. with text i lose the ability to calculate min and average.
How do i save stopwatch time to a collection while retaining the time format?