convert a number of seconds to HH:MM:SS?

[Steff_DK]

I use timer in my code.
It calculates the time elapsed by subtracting a number of seconds fro
another number of seconds e.g. 50256.3470 - 40155.1

The value returned, should be in the format HH:MM:SS.

How is this done in code?

I dont want to write any functions into ranges on the sheet or forma
any cells...

Thanks!!

 

[JWolf]

Divide the formula by 86400 and format the cell as hh:mm:ss.
86400=24 hrs*60min*60seconds. Excel stores time as the decimal fraction
of one day. i.e. 12:00:00=0.5, 18:00:00=0.75, etc.

 

[JWolf]

OK, no format:
range("A1").value=format(yourFormula/86400,"hh:mm:ss")