1

I am trying to format a list of names with times into the format hh:ss:mm from (n)h (n)m (n)senter image description here

If anyone knows how to do it that'd be so kind

player0
  • 124,011
  • 12
  • 67
  • 124
Ben
  • 37
  • 4

1 Answers1

1

try:

=FLATTEN(INDEX(QUERY(, "select  "&TEXTJOIN(",", 1, 
 SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(J2:J27, 
 "d", "*86400"), "h", "*3600"), "m", "*60"), "s", "*1"), " ", "+")))/86400, 2))
player0
  • 124,011
  • 12
  • 67
  • 124