Hi All ,

I am having Latency field (Data type Varchar 2(100)) in a database storing values like below

PT1M3S
PT4S
0000:01:46.0
0000:00:03.0

I want to write a formula to convert all above values into HH:MM:SS which mean

00:01:03
00:00:04
00:01:46
00:00:03

Can you please suggest how can i write this in a crystal report ??
Thanks In Advance for your help.

Regards
Vishal

I threw this code together yesterday.  It seems to work okay.  The one place I know that it will not display properly is if there are minutes but no seconds (i.e. PT2M, but will work if PT2M0S).

stringvar tempvar;
if {timedata_txt.Time} startswith "0" then
  tempvar := mid({timedata_txt.Time},6,5)
else
 (if instr({timedata_txt.Time},"M") <>0 then
    if isnumeric(mid({timedata_txt.Time},4,1)) then
        tempvar := mid({timedata_txt.Time},3,2)+":"
    else
        tempvar :=  "0"+ mid({timedata_txt.Time},3,1)+":"
  else
        tempvar := "00:";
  if  instr({timedata_txt.Time},"S") <>0 then
    if isnumeric(mid({timedata_txt.Time},len({timedata_txt.Time})-2,1)) then
        tempvar := tempvar + mid({timedata_txt.Time},len({timedata_txt.Time})-2,2)
    else
        tempvar := tempvar + "0"+mid({timedata_txt.Time},len({timedata_txt.Time})-1,1));
"00:"+tempvar