You have to first indentify hour,minutes & seconds from your time difference field using formula like
Hour =if length([time difference) = 7 then substr([time difference];1;1) else substr([time difference];1;2)
Minutes =if length([time difference) = 7 then substr([time difference];3;2) else substr([time difference];4;2)
Seconds = if length([time difference) = 7 then substr([time difference];6;2) else substr([time difference];7;2)
Now all of these would be measure objects
after that just add the hour ,minutes ,seconds by using variable
var_total = [hours]+[minutes]+[seconds]
another variable
var_hours = [var_total]/24
var_minutes = ([var_total] - [var_hours]*24)/60
var_seconds = [var_total] - [var_hours]*24-[var_minutes]*60
And then concate all the three variables which will give you result in hh24:mm:ss format.
Thanks,
Swapnil
Add comment