> Still looking for maybe a conversion or something. > The goal is to have the totaltime in a column in TIME format
The problem is that the TIME type does not hold a PERIOD of time -- it holds a clock time with respect to midnight. The difference of two TIME values is not, in fact, a clock time, but an elapsed time. R:Base gives it to you in a number of seconds. If you want to make your elapsed time in seconds look like an elapsed time in hours, minutes, and seconds, then you can: 1. Divide by 3600 for the hours, divide the modulus of the result by 60 for the minutes, and take the modulus of that result for the seconds, or 2. Use the extremely clever approach someone just posted of SET VAR vElapsed = (ADDSEC(0:00:00, .vElapsedSeconds)) which will give you a clock time that will APPEAR to the be elapsed time that you want (but that will actually represent, in your example, the time at 32 seconds past midnite). -- Larry
