i need to change a time format from

[Delz]

i need to change a time format from 235826.09 secs into time past 00.00.00 (12 o'clock +) hh/mm/ss/

I can't find a function to do this i want to say this is 23:58:26:00

Please help i've almost there

 

[blom0344]

Hello Delz,

Supposing your time format is a string, you would need an expression like this:

=SubStr(<variable>,1,2)&&quot; : &quot;&SubStr(<variable>,3,2)&&quot; : &quot;&SubStr(<variable>,5,2)&&quot; : &quot;&&quot;00&quot;.

If it is not a string, then first convert it to a string using FormatNumber()

blom0344