Thanks,
I tried your ex. but still did not get correct results. For ex., one of the records has -60.00 seconds for the time value. I got 00:00:00 instead of getting -00:01:00.

Here's my code:

DEFINE FILE TBLARCH
NUMSEC/I4 = START;
HOUR/I2 = (NUMSEC/3600);
MIN/I2 = ((NUMSEC/24 - (HOUR *60)));
HHMMSS/I6= INT( NUMSEC/3600 ) * 10000 + INT( IMOD(NUMSEC,3600,'I4')/60 ) * 100 + IMOD(NUMSEC,60,'I2');
TIME/A8=EDIT(HHMMSS,'99:99:99');

END

TABLE FILE TBLARCH
SUM
START
TIME
STOP
SCHEDULED
SIGNED_IN
COMPLIANCE

BY EMP_SHORT_NAME

Thanks for any assistance possible.

Joe,

Prarie's example works fine; you didn't mention that the values were negatives, so, just add:

NUMSEC/I4 = IF START LT 0 THEN START * (-1) ELSE START;

Also, if you always want to display as a negative:

TIME/A9= '-' | EDIT(HHMMSS,'99:99:99');

This works for positive numbers, I'm still trying to work out negative numbers.

DEFINE FILE CAR
NBR_SECONDS/D8 =
IF COUNTRY EQ 'ENGLAND'       THEN -60 ELSE
IF COUNTRY EQ 'FRANCE'        THEN 456666 ELSE
IF COUNTRY EQ 'ITALY'         THEN 127 ELSE
IF COUNTRY EQ 'W GERMANY'     THEN 180 ELSE
IF COUNTRY EQ 'JAPAN'         THEN -1 ELSE 481;

CURR_DATE/HHIS = HINPUT(14, '&YYMD.000000', 8, 'HYYMDS');
POS_DATE/HHIS = IF NBR_SECONDS GE 0 THEN HADD(CURR_DATE, 'SECOND', NBR_SECONDS, 8, 'HYYMDS') ELSE CURR_DATE;
END
-RUN

TABLE FILE CAR
PRINT
NBR_SECONDS
POS_DATE
BY COUNTRY
END
-RUN

Joe, what version are you on? Perhaps you could update you signature, as per this request: Friendly reminder: Please update your signatures
[/code]

Just for clarification, the only way to display what you want is in string format. There is no concept of negative time (only in the Twilight Zone) so any timestamp format would not work - it can't display -60 seconds. A combination of Prarie's code and Tom's addition for the negative will be what you're looking for. You'll first have to make seconds positive then add the negative after making calculations.

quote:

WebFOCUS 7.6.1 Win 2003

Thanks,

I'm going to try Tom's suggestion. I think I can make that work.

Joe