I am trying to recode these variables (1 to 61 for each day) to what I believe is called datetime syntax, so that for “day 1,” what SPSS currently coded as “2” will become 12:00am on Day 1 (or on an arbitrary day), and so that variable 58, for instance, would be coded as 4:00am on day 2.

I have struggled with how to recode these so that I can then manipulate the dates and times to calculate individual and group averages, activity durations, and the like. I am fine with picking arbitrary “dates” for days 1-8, but I am having trouble with the correct recoding syntax for datetime. Any help would be much appreciated!

-grateful grad student