Solved

# Convert Decimal Number to HH:MM:SS

Posted on 2006-07-14
4,912 Views
Hello Experts:
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.)

Examples:
Decimal Hours= Desired result
0.03 = 00:01:48
2.25 = 02:15:00

Summarized as:
02:16:48

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.

TIA!

0
Question by:boris711

LVL 17

Expert Comment

ID: 17111635
CR has a function called TIME(number)
the number can be decimal
Use a forumla to convert the field(type number) to type time
Then use the fomula where ever required.

ex: 2.83 converts to  7:55:12PM
18.87 converts to  8:52:48PM

You might use CTime because you can only use Time in Crystal syntax as it is a type name in Basic syntax.

CTime (number) converts the given number to a Time value; the given number is in units of 24 hours, can be fractional or negative as well.

Hope it helps
MikeV
0

LVL 6

Accepted Solution

Ken Turner earned 250 total points
ID: 17111756
Conversion of the detail items is easy: TimeValue ({YourHours}/24).

Assuming you accuimulate a total of {YourHours}, conversion of the total is a bit more tricky because of the HH > 24 situation; the following formula converts the accumulated hours into a string in the format hh:mm:ss:

Totext({YourHours},0,'') + ':' + totext(timevalue({YourHours} / 24),'mm:ss')
0

LVL 1

Author Comment

ID: 17218710
While neither comment hit exactly what I was looking for KenTurner's gave me a new perspective. Thank you both for responding.
0

## Featured Post

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.