I would say that's "how do I extract the date stamp that is the first 8 characters of my PNR value"?
The time subtraction is just a case of using the available date functions in Oracle.
The code you have at the moment:
is actually backwards.
You want to to_date the first 8 characters of the PNR, and then subtract them from sysdate, to get a duration.