On Saturday, September 8, 2012 3:09:38 AM UTC-5, Stephen wrote:
Hello, can someone explain how and where does this code go to get it to work?

Does it go in general macro or do I need to put in a module.



Private Function SecondsToTime(byval dSeconds as Double) _

as String

SecondsToTime = Format(DateAdd("s", dSeconds, "00:00:00"), "HH:mm:ss")

End Function





regards

Stephen

Assuming your function is OK it needs to go into a REGULAR module. Not a sheet module