Runtime calculation in HH:mm:SS in UC4 V12

[Legacy User]

How to calculate the Runtime/duration of an completed job in UC4  by fetching the values &start# and &end# from another script. and store the value in HH:MM:SS format

[Anon Anon]

Hi

The best attempt would be using an adequate salutation prior to your question.
Using any words of thankfulness would offend nobody as well. :)

As answer you would probably get the information to look at the available script commands - especially for date & time calculation...

https://docs.automic.com/documentation/WEBHELP/English/AWA/11.2/AE/11.2/All%20Guides/help.htm#uczach.htm%3FTocPath%3DAutomation%2520Engine%2520Script%2520Guide%7COrdered%2520by%2520Function%7C_____0

cheers, Wolfgang

[Legacy User]

GET_STATISTIC_DETAIL

[Legacy User]

Hi Wolfgang,
Sorry for missing the salutation Part.

I checked the given link for the available commands in Automic. I  able to get the solution for that part in seconds format.

But i want it in HH:MM:SS. Format.Is it possible?

[Anon Anon]

Hi Ganesh

Yes of course its possible, but not with builtin functions as far as I know :-(

But there are the DIV and MOD script functions that will do the trick:


:SET &SECS# = 13657

!calc minutes and rest of seconds
:SET &MINS# = DIV(&SECS#,60)
:SET &SECS# = MOD(&SECS#,60)

!calc hours and rest of minutes
:SET &HRS# = DIV(&MINS#,60)
:SET &MINS# = MOD(&MINS#,60)

!beautify output
:SET &HRS# = FORMAT(&HRS#,"00")
:SET &MINS# = FORMAT(&MINS#,"00")
:SET &SECS# = FORMAT(&SECS#,"00")

:PRINT "Time elapsed: &HRS#:&MINS#:&SECS#"

Report:
2017-11-21 08:55:09 - U00020408 Time elapsed: 04:48:37