I want to create a Username from First 5 Chars of 2 field and insert this into field Username - is there an example of this anywhere?
I also want to create a pace for running times for example 10 km in 45 mins
10 = 6.2 miles where http://www.google.co.uk/search?q=miles+in+a+km 1 kilometre = 0.621371192 miles
00:45:00 / 6.2 = 00:07:15 minutes per mile and hence calculate Miles/hour Km/hour mins/km
Mins Miles Mins/Mile Hour Miles/Hour Km in a Mile Km/Hour Mins/Km
00:45:00 6.2 00:07:15 01:00:00 8.26666 0.621371192 13.303 00:04:31
Ideally show miles column but convert from km if that column is filled in.
Null 5
Null 5
5 3.1
10 6.2
Null 6
Even better would be to also have a tick box for marathon and half marathon which would enter a specified rounded figure in the miles section.
http://www.google.co.uk/search?q=miles+in+a+marathon
1 marathon = 26.21875 miles
Any links or suggestions gratefully received - Chris