RUA Volunteer2?
asked on
Converting unique timestamp PT0H30M into a value I can work with
I need to convert this value (PT0H30M) into a number I can easily sum across all records and be able to get a simple solution to display hours and mins easily so that it is clear to the viewer.
SS-SMGB-TimeConv.jpg
SS-SMGB-TimeConv.jpg
Can you provide what the expected output is for the different examples?
ASKER
The expected output would be a number that I can sum and or divide back into an hour minute format. I guess if you converted it then added only minutes then I could just devide by 60 and get all the hours and the remainder would be the minutes.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works perfectly. Thank you sir. I am employed for yet another week. Hopefully my job will not get shipped to India.