Solved

Convert Decimal Number to HH:MM:SS

Posted on 2006-07-14
3
4,986 Views
Last Modified: 2008-09-03
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
Comment
Question by:boris711
3 Comments
 
LVL 17

Expert Comment

by:MIKE
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

by:
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

by:boris711
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question