How to keep the result in HH:MM:SS when doing subtraction

[EngJoo]

Dear all,

i would like to know the formula for keep the result in HH:MM:SS when i am doing the subtraction between 2 different time.

please advice.

 

[Naith]

You need to convert ToSeconds when subtracting.

When you have your ToSeconds total, reconvert it using the following:

WhilePrintingRecords; 
NumberVar SecondsTotal := {YourSecondsTotalField}; 
NumberVar MyHour := Truncate(Remainder(SecondsTotal,86400)/3600); 
NumberVar MyMinute := Truncate(Remainder(SecondsTotal,3600)/60); 
NumberVar MySecond := Remainder(SecondsTotal,60); 

ToText(MyHour,'00',0,"")+':'+ToText(MyMinute,'00',0,"")+':'+ToText(MySecond,'00',0,"");

Naith

 

[kataka]

why not just this:
TimeValue({Date1} - {date2)

 

[Naith]

You're very probably right, Kataka. But I can only get the TimeValue to return accurately when used in conjunction with DateTime fields, rather than Time fields.

That said, if the fields here are DateTime fields, then yours is hands down the better option.

Naith