Convert sconds in HH:MM:SS

[marko001]

Hi all guys,

is there a simple way to convert seconds (i.e. 11465) in standard time (11465s = 03:11:05)

Thanks everyone,

Marco

[Melba23]

marko001,

is there a simple way

Yes, basic maths.

M23

[marko001]

Prrr! I know it... thought an UDF could be of help

[water]

Multiply your seconds by 1000 and then use _TicksToTime to convert to hours, minutes and seconds.

[marko001]

Great, done though using "standard" maths but better using that hint. Thanks Water

[water]

As usual there are many ways to skin a cat

[UEZ]

Try this:

Func Convert($t)
    $h = Floor($t / 3600)
    $m = Floor(($t - $h * 3600) / 60)
    $s = Mod($t, 60)
    Return StringFormat('%02i:%02i:%02i',$h, $m, $s)
EndFunc

Br,

UEZ

Edited December 3, 2010 by UEZ

[whim]

Or this ...

#include <Date.au3>  
Global $test = 11465

MsgBox(0, "Test", "input = " & $test & @CRLF & "return = " & _SecsToTime($test) )

Func _SecsToTime($secs)
    Local $hh, $mm, $ss
    _TicksToTime($secs * 1000, $hh, $mm, $ss)
    Return StringFormat("%02d:%02d:%02d", $hh, $mm, $ss)
EndFunc

[Malkey]

Another skinless cat.

Local $iSecs = 3723

Local $sHMS = StringFormat('%02i:%02i:%02i', Floor($iSecs / 3600), Floor(Mod($iSecs, 3600) / 60), Mod($iSecs, 60))

MsgBox(0, "Result", $iSecs & " secs = " & $sHMS)

Edit: Calculating minutes, changed from "Floor(($iSecs - (Floor($iSecs / 3600)) * 3600) / 60)" to a simpler formula, "Floor(Mod($iSecs, 3600) / 60)".

Edited December 3, 2010 by Malkey