I am getting an value of TimeStamp in a format of ‘wD xH yM zS’ in an excel sheet having multiple rows.
I want to filter out the rows having timestamp more then 3 hours into separate excel.
Also if in case timestamp is just 10 hours 30 minutes 10 seconds then it will be mentioned as ‘10H 30M 10S’. without any D in the format (0D 10H 30M 10S).
Kindly help me with the logic for handling such scenario.