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