A client asked me to add a feature. The athletes run without watches and before the race each one has to give an estimated or expected time they would finish the race. The one with the closest to the actual time wins.
I subtract the finishtime from the starttime to get actual racingtime. Then i subtract the Expected time from this actual racingtime.
It must then be sorted to the one closest to the actual time.
Calculating the difference between the finish and starttimes is easy, but the last part is giving me grey hairs.
The code used to calculate the actual racingtime in query
Expand|Select|Wrap|Line Numbers
- RacingTime: Format([TimeFinish]-[TimeStart],"hh:nn:ss")
i tried this in query
Expand|Select|Wrap|Line Numbers
- TimeDiffs: Format$(IIf(IsNull([Racingtime]-[ExpectTime]),0,CDate([Racingtime]-[ExpectTime])),"hh:nn:ss")
i will appreciate help