Home > Enterprise >  Google Sheet Split from 24:00 forcing to 24:00:00.000
Google Sheet Split from 24:00 forcing to 24:00:00.000

Time:09-16

I'm trying to work this out, can't find a solution.

The string, after REGEXEXTRACT is 20:00 24:00 25:00

I've been banging my head for hours, trying ways to convert, after the split, to get this result:

20:00 24:00 25:00

But it turns out that Google Sheets always forces:

20:00 24:00:00 25:00:00

Tried converting to text, using arrayformula, formatting cell as custom date, etc. Nothing has worked, so far.

Here a sheet example, already with the SPLIT result and the desired result.

enter image description here

  • Related