AnsweredAssumed Answered

How to converting the 8-digit time stamp

Question asked by Allen Li on Mar 30, 2018
Latest reply on Aug 22, 2018 by rogrant@nmsu.edu

Dear all: I am teaching a big class and would like to use Excel to assign bonus to students if they submitted the assignment prior to a given date. I have downloaded all submissions from Canvas. Below is an example file name for a student's submission.

 

userid_61900XX_65052415_ProblemSet2.xlsx

 

I know the first number (61900XX) is a student's unique id for my Canvas course and the second number (8-digit: 65052415) seems to be a time stamp of assignment submission. This number doesn't look like a standard Unix time stamp. My question is: Is there a way to convert this 8-digit number into the format I can recognize, like 2018-03-28 13:23?  Thanks! 

Outcomes