Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Didn't Time myself because I am not interested in doing so really, more so the solution / end goal.
Here's what I got though:
Workflow:
Formulas:
Spoiler
Race Name:
REGEX_Replace([FileName],"(\w*)(\-.*)","($1)")PitTime:
"2024-06-12 " + REGEX_Replace([Value],"(\d\s.*\s)(.*)","($2)")PitStopTime:
DateTimeDiff([PitTime],[Row-1:PitTime],"sec")Solution Check:
Spoiler
Expected:
Actual:
