Forum Discussion
Totara SCO total time
Hi all,
We are using Totara v12, and we have a report that shows SCO total time which is super helpful. Most of the records are displaying correctly like 00:08:36.12 meaning the user spent 8 mins ...
Hi Andrew!
That timestamp is a special SCORM 2004 formatted timestamp, and time intervals must be sent to the LMS that way to meet SCORM 2004 specifications.
However, our team created an Excel formula for you that can parse the timestamp into a "standard" format of
XXHXXMXX.XXS! This should make easier to parse time interval data sent from SCORM 2004 content.The attached demo worksheet includes the "Combined" formula that allows for single-cell parsing of SCORM's PT time format to a XXHXXMXX.XXS format. It also splits out the formula into it's component parts, in the event you want to make any adjustments. The entire formula is as follows, with A2 being the cell that contains the PT timestamp.
=CONCATENATE(IF(ISERR(FIND("H",A2)),"00H",IF(FIND("H",A2)-FIND("T",A2)=2,CONCATENATE("0",LEFT(REPLACE(A2,1,2,""),FIND("H",REPLACE(A2,1,2,""),1))),LEFT(REPLACE(A2,1,2,""),FIND("H",REPLACE(A2,1,2,""),1)))),IF(ISERR(FIND("M",A2)),"00M",IF(ISERR(FIND("H",A2)),IF(FIND("M",A2)-FIND("T",A2)=2,CONCATENATE("0",MID(A2,FIND("T",A2)+1,FIND("M",A2)-FIND("T",A2))),MID(A2,FIND("T",A2)+1,FIND("M",A2)-FIND("T",A2))),IF(FIND("M",A2)-FIND("H",A2)=2,CONCATENATE("0",MID(A2,FIND("H",A2)+1,FIND("M",A2)-FIND("H",A2))),MID(A2,FIND("H",A2)+1,FIND("M",A2)-FIND("H",A2))))),IF(ISERR(FIND("M",A2)),IF(LEN(A2)-FIND("T",A2)=2,CONCATENATE("0",RIGHT(A2,LEN(A2)-FIND("T",A2))),RIGHT(A2,LEN(A2)-FIND("T",A2))),IF(LEN(A2)-FIND("M",A2)=2,CONCATENATE("0",RIGHT(A2,LEN(A2)-FIND("M",A2))),RIGHT(A2,LEN(A2)-FIND("M",A2)))))
