Find my approach in attached workbook, I took your mentioned string as sample and demonstrated the output take a look.
1. Using DATEPARSE() I've converted your string into datetime field (Time) which is your Arrival Time. Then changed the default format of that field using Custom "hh:nn AMPM"
2. Secondly I've created an integer parameter for Interval time addition
3. Using DATEADD() I've created a field to get New Arrival Time. Same as Arrival Time, changed the default datetime format of the field to "hh:nn AMPM".
Let us know if this help.
Hi Mahfooj, Thanks for looking into this. You are almost there in my case but
my arrival time field doesn't have AM/PM. it is simply string values like 08:20, 10:20 etc.
actually i want to compare the actual arrival time field with the newly constructed field after addition of parameter values.
if arrivaltime <new_arrivaltime then 'something' END
i have tableau version 10.1, so can not open your workbook.