Hey,

my report is based on a database.
In the database their is an integer field with the time in seconds.
The people who uses the report wants to view this number in
hours:minutes:seconds. Changing the database is a no go, because the program uses those seconds to calculate several things.

I formated the number with a calculation in the formula editor but now it always shows decimals.
My question is how to remove those decimals.

For example:
Database : 554
after calculating it becomes 9 min and 14 seconds but the report displays it like this: 0,00:9,00:14,00

My code to do this is:
Local numberVar i := ToNumber({tblGesprek.duratiecommunicatie});
Local stringvar outputString := "";
Local numberVar uren := 0;
Local numberVar minuten := 0;
Local numberVar seconden := 0;

while i >= 3600 do
(
uren := uren + 1;
i := i - 3600;
);

while i >= 60 do
(
minuten := minuten + 1;
i := i - 60;
);
seconden := i;

uren := Truncate(uren);
minuten := Truncate(minuten);
seconden := Truncate(seconden);

outputString := ToText(Truncate(uren)) + ":" + ToText(Truncate(minuten)) + ":" + ToText(Truncate(seconden));


the code to calculate the time is correct but i want the decimals to disappear!
How is this possible??

Thanks in advance and sorry about the english