distance to finish timer

[Callmeshack]

Does gruss have a distance to finish timer? Or a race timer? obviously this is for in play races. thanks

[GaryRussell]

Sorry this is not a feature currently. It maybe added in the future.

[brumbie]

This is the one I have been using for quite some time now, and it is reasonably accurate for its purpose.

Code: Select all

=IF(ISERROR(FIND("2m4f",$A$1))=FALSE,324,IF(ISERROR(FIND("3m1f",$A$1))=FALSE,381,IF(ISERROR(FIND("2m1f",$A$1))=FALSE,258,IF(ISERROR(FIND("2m3f",$A$1))=FALSE,282,IF(ISERROR(FIND("2m6f",$A$1))=FALSE,355,IF(ISERROR(FIND("2m2f",$A$1))=FALSE,263,IF(ISERROR(FIND("1m6f",$A$1))=FALSE,212,IF(ISERROR(FIND("1m3f",$A$1))=FALSE,135,IF(ISERROR(FIND("2m5f",$A$1))=FALSE,326,IF(ISERROR(FIND("2m7f",$A$1))=FALSE,354,IF(ISERROR(FIND("1m4f",$A$1))=FALSE,142,IF(ISERROR(FIND("1m2f",$A$1))=FALSE,125,IF(ISERROR(FIND("1m5f",$A$1))=FALSE,189,IF(ISERROR(FIND("1m1f",$A$1))=FALSE,102,IF(ISERROR(FIND("3m3f",$A$1))=FALSE,419,IF(ISERROR(FIND("3m7f",$A$1))=FALSE,389,IF(ISERROR(FIND("3m4f",$A$1))=FALSE,467,IF(ISERROR(FIND("3m2f",$A$1))=FALSE,393,IF(ISERROR(FIND("3m5f",$A$1))=FALSE,476,IF(ISERROR(FIND("3m6f",$A$1))=FALSE,450,IF(ISERROR(FIND("4m1f",$A$1))=FALSE,523,IF(ISERROR(FIND("4m3f",$A$1))=FALSE,520,IF(ISERROR(FIND("1m7f",$A$1))=FALSE,228,IF(ISERROR(FIND("4m2f",$A$1))=FALSE,546,IF(ISERROR(FIND("5f",$A$1))=FALSE,55,IF(ISERROR(FIND("6f",$A$1))=FALSE,61,IF(ISERROR(FIND("7f",$A$1))=FALSE,79,IF(ISERROR(FIND("4m",$A$1))=FALSE,497,IF(ISERROR(FIND("3m",$A$1))=FALSE,360,IF(ISERROR(FIND("2m",$A$1))=FALSE,228,IF(ISERROR(FIND("1m",$A$1))=FALSE,91," ")))))))))))))))))))))))))))))))

You just have the clock subtract from it.

[brumbie]

This is the one I have been using for quite some time now, and it is reasonably accurate for its purpose.


=IF(ISERROR(FIND("2m4f",$A$1))=FALSE,324,IF(ISERROR(FIND("3m1f",$A$1))=FALSE,381,IF(ISERROR(FIND("2m1f",$A$1))=FALSE,258,IF(ISERROR(FIND("2m3f",$A$1))=FALSE,282,IF(ISERROR(FIND("2m6f",$A$1))=FALSE,355,IF(ISERROR(FIND("2m2f",$A$1))=FALSE,263,IF(ISERROR(FIND("1m6f",$A$1))=FALSE,212,IF(ISERROR(FIND("1m3f",$A$1))=FALSE,135,IF(ISERROR(FIND("2m5f",$A$1))=FALSE,326,IF(ISERROR(FIND("2m7f",$A$1))=FALSE,354,IF(ISERROR(FIND("1m4f",$A$1))=FALSE,142,IF(ISERROR(FIND("1m2f",$A$1))=FALSE,125,IF(ISERROR(FIND("1m5f",$A$1))=FALSE,189,IF(ISERROR(FIND("1m1f",$A$1))=FALSE,102,IF(ISERROR(FIND("3m3f",$A$1))=FALSE,419,IF(ISERROR(FIND("3m7f",$A$1))=FALSE,389,IF(ISERROR(FIND("3m4f",$A$1))=FALSE,467,IF(ISERROR(FIND("3m2f",$A$1))=FALSE,393,IF(ISERROR(FIND("3m5f",$A$1))=FALSE,476,IF(ISERROR(FIND("3m6f",$A$1))=FALSE,450,IF(ISERROR(FIND("4m1f",$A$1))=FALSE,523,IF(ISERROR(FIND("4m3f",$A$1))=FALSE,520,IF(ISERROR(FIND("1m7f",$A$1))=FALSE,228,IF(ISERROR(FIND("4m2f",$A$1))=FALSE,546,IF(ISERROR(FIND("5f",$A$1))=FALSE,55,IF(ISERROR(FIND("6f",$A$1))=FALSE,61,IF(ISERROR(FIND("7f",$A$1))=FALSE,79,IF(ISERROR(FIND("4m",$A$1))=FALSE,497,IF(ISERROR(FIND("3m",$A$1))=FALSE,360,IF(ISERROR(FIND("2m",$A$1))=FALSE,228,IF(ISERROR(FIND("1m",$A$1))=FALSE,91," ")))))))))))))))))))))))))))))))


You just have the clock subtract from it. (doesn't seem to be an edit, strange)