Working with Time
Working with Time
Hi
I am trying to build a DB to record my runs. As there is not a 'time' data type that can cope with durations, rather than time of day, I have resorted to a text field to accept my times in the format hh:mm:ss. This data sorts ok in a form, but I cannot produce a pivot report to show me the minimum time for a run - presumably because zoho can't return the min of a string data type.
I already have a function to convert my hh:mm:ss into a numerical value in seconds, so I could use this in the pivot, but a value of 4536 seconds is not very meaningful. Any suggestions as to how I can find my quickest time for each run?
Has someone already developed a sport tracking application that I can use as a starter?
Mike