Re: calculate the difference between two time stamps in hh:mm:ss

Richard B Baird wrote:
> 
> good morning all,
> 
> I've searched the archives, but didn't find much help - I'm trying get
> hh:mm:ss from the difference between two timestamp fields for displaying in
> user readable format on a dspf.
> 

Richard, you can't directly get a time from subtracting two timestamps
because a time represents a time of day, not a duration.  Try adding the
seconds to a time value of 00.00.00 to get your duration in a Time
field.

Try this:

      time = t'00.00.00' + %seconds(%diff(ts1 : ts2 : *seconds));

or this:

c    ts1          subdur    ts2             secs:*seconds
c    t'00.00.00'  adddur    secs:*seconds   time