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 (v2.6.0))
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")
Perfect 
I like the trick of using the template column to turn the ‘primitive’ value into text Thanks - everything is working now 
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.
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.
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
