marko001 Posted December 3, 2010 Share Posted December 3, 2010 Hi all guys, is there a simple way to convert seconds (i.e. 11465) in standard time (11465s = 03:11:05) Thanks everyone, Marco Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted December 3, 2010 Moderators Share Posted December 3, 2010 marko001,is there a simple wayYes, basic maths. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
marko001 Posted December 3, 2010 Author Share Posted December 3, 2010 Prrr! I know it... thought an UDF could be of help Link to comment Share on other sites More sharing options...
water Posted December 3, 2010 Share Posted December 3, 2010 Multiply your seconds by 1000 and then use _TicksToTime to convert to hours, minutes and seconds. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
marko001 Posted December 3, 2010 Author Share Posted December 3, 2010 Great, done though using "standard" maths but better using that hint. Thanks Water Link to comment Share on other sites More sharing options...
water Posted December 3, 2010 Share Posted December 3, 2010 As usual there are many ways to skin a cat My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
UEZ Posted December 3, 2010 Share Posted December 3, 2010 (edited) 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 Please don't send me any personal message and ask for support! I will not reply! Selection of finest graphical examples at Codepen.io The own fart smells best! ✌Her 'sikim hıyar' diyene bir avuç tuz alıp koşma!¯\_(ツ)_/¯ ٩(●̮̮̃•̃)۶ ٩(-̮̮̃-̃)۶ૐ Link to comment Share on other sites More sharing options...
whim Posted December 3, 2010 Share Posted December 3, 2010 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 Link to comment Share on other sites More sharing options...
Malkey Posted December 3, 2010 Share Posted December 3, 2010 (edited) 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now