Hi,
I have a formula in a field that returns values in seconds that converts it to HH:MM:SS
In the display string formula box for this field I have entered:
Local numberVar TimeInSeconds := Round(CurrentFieldValue , 0);
Local numberVar hours := Truncate (TimeInSeconds / 3600, 0 );
Local numberVar minutes := Truncate ((Remainder (TimeInSeconds,3600) / 60 ),0 ) ;
Local numberVar seconds := Remainder (TimeInSeconds,60);
ToText(hours,"00")& ":" & ToText(minutes,"00")& ":" & ToText(seconds,"00")
However...when I view the report after exporting to excel....it still returns the fields in seconds. It is fine in PDF or crystal viewer, but excel returns the format to seconds. Help!?
IP Logged
