Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEADidn'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:
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:
Actual:
great show case of multi row formula tool 👨💻
@Qiu - I have nightmares about it 😂