Convert Decimal Number to HH:MM:SS
Posted on 2006-07-14
We have a FireBird DB from which we're using CR XI to pull a decimal number that represents hours spent on a project.
I'd like to convert this decimal number to appear in my reports in the format of: "HH:MM:SS" (without any reference to AM/PM, as that is irrelevant)
But I will also need to summarize the column that holds these times into the same format, thus performing math on the converted numbers. (without conversion to days at HH > 24.)
Decimal Hours= Desired result
0.03 = 00:01:48
2.25 = 02:15:00
I'm sure I can work out the math, multiplying the initial decimal by 3600 for total SS, and working my way from there to MM and HH, but am wondering if there is a shorter method within CR XI.