Time format conversion and manipulation

[Former Member]

Hi!

I've the following time format in a flat file. 00:03:21,945

HH:MM:SS,TTT, where T = second / 1000

I would like to manipulate this format, by adding some seconds to it (for example add 39 seconds) then write it back to the file in the given format.

What do you think what is the best solution for this?

Please don't answer quickly with 2 words, I'll give points for the best solutions.

Regards

Tamá

[Former Member]

hi

this is u r format HH:MM:SS,TTT..

take this into one variable...let var

take last three char into one variable var2.

var2 = var19(3).

now add 39 seconds to this var2..

and move this var2 in to var19(3)...

reward points...

if help full

[Former Member]

Hi,

you need to check for the seconds if the time is like this 11:59:30 + 39 sec addition, then you have to use a Fm

split the file time at , into one variable then call the FM

WLF_RRLE_ADD_TIME or

DIMP_ADD_TIME

then pass the values to add

IV_STARTTIME 11:59:20

IV_STARTDATE

IV_STARTTIME 11:59:20

output

EV_ENDTIME 11:59:59

EV_ENDDATE

again concatanete the same separating the by ,

hope this helps

regards

Shiva