Any joy turning 12 hour time to 24?

I have @Mark 's HYC code, and I am trying to turn 12:00 PM or 08:30 PM into nice 24 hour time (so 12:00 or 20:30).

I am using the Excel formula : =TEXT(A1,”HH:MM:SS”)
and this is seemingly supported on HyperFormula (Built-in functions | HyperFormula (v1.0.0))

  • but no joy so far.

Has anyone else managed this? Thanks! M

Hola @Mark_Turrell

This may not be the most beautiful way but I think it works.

You need to first turn your time into a string (template column)

The use the Excel Formula code in a YC and add this formula: =TEXT(A1,"[hh]:mm:ss")

4 Likes

Perfect :slight_smile: I like the trick of using the template column to turn the ‘primitive’ value into text :slight_smile: :slight_smile: Thanks - everything is working now :slight_smile: :star: :star2:

3 Likes

Did it not work because Mark had the full date & time under the hood, instead of a text field like you did with the template?

I don’t really know but I guess that was the reason.

1 Like

The Yes-code did not want to process the value as it came in, so a detour through an extra column to make it a text string with the template allowed it to be handled properly with the excel formula.

2 Likes

this is my solution for time formats, instant check if a business is open, AM/PM - 24H switch, with no YC or any script used: SAMPLE

Screen Shot 2021-08-08 at 6.52.09 PM

1 Like