Seconds to H:MM:SS format

[OKCMikeSoll]

I currently have a variable that gives me the total number of seconds between two dates, but I cannot find a function to convert the total number of seconds into the format H:MM:SS

I searched the posted and did not find anything out there. If anyone has any suggestions I would be greatful.


Thanks,
Mike Soll

 

[vongrunt]

One trick:

formatDateTime( numberOfSeconds/86400, vbLongTime )

------
heisenbug: A bug that disappears or alters its behavior when one attempts to probe or isolate it
schroedinbug: A bug that doesn't appear until someone reads source code and realizes it never should have worked, at which point the program promptly stops working for everybody until fixed.
[ba

 

[steven290]

here is an adoptation to vongrunt's method

<%
hhmmss=formatDateTime( numberofseconds/86400,vbLongTime)
response.Write left(hhmmss,len(hhmmss)-3)
%>