bouncingtigers
Registered User.
- Local time
- Today, 10:23
- Joined
- Aug 9, 2016
- Messages
- 18
Afternoon everyone
Im pretty new to this so please go lightly on me.
I have a table:
name, swimtime, score
john 18:00
smith 22:00
I m looking to score swimmers based on the time they swam a race - Example such as scoring 50 points if they finished in under 20 minutes - I thought a calculated field could achieve it but cant work out, nor find online anywhere how to score it.
I have been trying to do this: if([Swim] <= & 00:20:00, [50])
Any help would be hugely appreciated
Thank you in advance
Im pretty new to this so please go lightly on me.
I have a table:
name, swimtime, score
john 18:00
smith 22:00
I m looking to score swimmers based on the time they swam a race - Example such as scoring 50 points if they finished in under 20 minutes - I thought a calculated field could achieve it but cant work out, nor find online anywhere how to score it.
I have been trying to do this: if([Swim] <= & 00:20:00, [50])
Any help would be hugely appreciated
Thank you in advance