Convert Hours (decimal) to HH:MM format
It is possible to take a decimal integer and convert it to a standard HH:MM time format utilizing AskiaScript.
Below, is an example excerpt:
Dim D
Dim e
D = q1.Value
e = "" + ((D - Int(D)) / 100 * 60).Round(2) + "0"
Return "" + Int(D) + ":" + Mid(e, 3, 2)
For instance, if a value of 1.25 was imported the value returned would be 1:15 for 1 hour and 15 minutes.
An example QEX file is also included to this article.