Calculating Chronotype (lark or owl?) of Survey Participants

Hello dear Community!


I am currently working on a survey, trying to split a group of participants into larks and owls, meaning "do they go to bed early and get up early or do they go to bed late at night and therefore sleep longer during the day?".
For that I am using an already existing and renowned questionnaire called "MCTQ" (Munich Chronotype Questionnaire).
Being an excel-newbie, with the help of you guys I already managed to compute most of the variables I need using the variable computation sheet of the MCTQ (pdf attached) for example the sleep duration on work days and free days of the participants.
Now I am trying to split the group into "larks" and "owls".
Therefore I had to calculate the point of mid-sleep on free days and work days (MSF/MSW, see variable computation sheet) and combine it with the average weekly sleep duration.
This allowed me to calculate a number for which I said "if smaller than or exactly 0,5 it's an owl, if bigger than 0,5, it's a lark.".
In order to erase errors and to get more opinions on if this makes sense or if I maybe am a complete mess here I wanted to show it to you guys, maybe some people are interested and want to get into it!

I attached all of the data as well as the computation sheet. It ain't all too much and I coloured all the interesting variables which appear in the computation sheet. No sensitive data involved, it's anonymized.

Greetings from Hamburg, Germany


Winston