Crystal Reports, BOXIR2, Oracle DB summary of hrs/mins miscalculating

[hsandwick]

The field being retrieved from the database is a string field, but is presented as

1:00
1:15
(hrs:mins).
Total should be 2:15

Summarization of the field does not calculate correctly.

So, convert the field to number type as total mins, e.g.

60
75
Total 135.

How do I calculate that 135 back to the correct summarization of 2:15 in string format (presented as hrs:mins)?

Thank you in advance,

Helen

 

[Turkbear]

Hi,
Build 2 strings ( and 1 more that is just ":" )from the result of
135/60
using the substr and concatenation operators..

I'll leave the details to you...





To Paraphrase:"The Help you get is proportional to the Help you give.."