Converting numbers to MM:SS format in Cross-tab

Question

I'm trying to convert a value in Cross-tab of Crystal report into a MM:SS format. I used the following steps: Right-click summary > Format Field > Display String > x+2

WhilePrintingRecords;
NumberVar curr := CurrentFieldValue;
NumberVar mins := Truncate(curr / 60);
NumberVar secs := Remainder(curr, 60);
ToText(mins, 0, "") & ":" & ToText(secs, 0, "")

The results are ok when the secs is not 0. Example: `4:30'

But, I am having problems when secs is 0, the result is (for 4 minutes): 4:0

I would like to have the output as 4:00, with the seconds display as always a 2 digit number.

Thank you for all your help

For one, you don't need `WhilePrintingRecords`. – craig Dec 03 '12 at 02:01 — craig, Dec 03 '12 at 02:01

score 0 · Answer 1 · answered Dec 03 '12 at 02:03

0

You my ElapsedTime function in conditional-formatting expression.

answered Dec 03 '12 at 02:03

craig

25,664
27
119
205

score 0 · Answer 2 · answered Dec 03 '12 at 03:01

0

I used this instead, and it worked :)

NumberVar curr := CurrentFieldValue;
NumberVar mins := Truncate(curr / 60);
NumberVar secs := Remainder(curr, 60);
ToText(mins, 0, "") & ":" & ToText(secs, '00')

answered Dec 03 '12 at 03:01

bcmacariola

106
2
15

Converting numbers to MM:SS format in Cross-tab

2 Answers2