Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Formatting times for a race

Highlighted
6 - Meteoroid

I'm trying to format times for a spreadsheet on a long-running race. The sheet has columns for [overall time] and [pace time]. [Overall time] is formatted as hh:mm:ss, while [pace time] is formatted as mm:ss. I've tried just changing it to the time type with the select tool, but it isn't allowing this. I suspect this is because the time type is only allowing time of day, not time as a duration. Would anyone know how to fix this?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
While you could store 30:15 as a string, you might want to store it as an integer as:

ToNumber(regex_replace([pace],"(\d+):\d+",'$1'))*60 +
ToNumber(Regex_Replace([pace],"\d+:(\d+)",'$1'))

This is the number of seconds

Cheers,
Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels