I’m trying to create a way for runners to upload their mile times and have a searchable directory of miles times. There are two ways I’ve considered going about this:
- Entering mile times in seconds which will work but it’s as useful to the user. For example, if you ran a 4:48 mile but you saw that you ran a mile in 288 seconds, that doesn’t mean anything to most people unless I can convert this to show mm:ss on the display but I can’t figure this out either
- Entering mile times as a date / time value. In theory this makes sense in my head but the filter is not working (see picture for reference) and I’m not sure if this will be impacted by different timezones or have other complications
Any suggestions or help would be greatly appreciated! Thank you!