Totara SCO total time

I have a current, related issue while reporting SCO total time across our LMS (Moodle/Totara) which appears to report SCO total time just as the SCO SCORM driver presented it. We have a mixture of SCORM1.2 and SCORM2004 all built with Storyline and Rise. SCORM1.2 SCO total time is recognised as a time format by excel, so can be totalled, pivottabled etc.

However, the SCORM2004 are reported in a distorted version of the SCORM2004 elapsed time format (PTxxHxxMxx.xxS) - see examples below. Clearly, Excel cannot understand this and I'm not entirely sure this format should be externalised by the Storyline driver.

I have a couple of questions. I haven't snooped the browser traffic on this but have the LMS SCO log. Is it absolutely necessary for the Articulate driver to return this format? Wouldn't a conventional hh:mm:ss.0 format make more sense?
If it is absolutely necessary to externalise the SCORM2004 time format, how about a SCORM2004 compatible fixed width format such as xxHxxMxx.xxS, so it can be easily parsed via Excel or other simple tools?

For example - these are SCO total times reported by Storyline SCORM2004 objects:

• PT34.93S (in my opinion could read PT00H00M34.93S)
• PT6.78S (in my opinion could read PT00H00M06.78S)
• PT8M (in my opinion could read PT00H08M00.00S)
• PT1H30.92S (in my opinion could read PT01H00M30.92S)

If there's a Storytime hidden setting to report SCO2004 time conventionally, please let me know. If somebody has built an Excel formula or VBA to decode this, I'd love a copy please. If I'm incorrect in my assumptions, please also advise.

In a mixed-format LMS scenario, these time format variations are painful. Respectfully, the SCORM2004 format as implemented, compounds that obstruction.

Thank you
-Andrew