Oct 03 2021 03:37 AM
Hey guys,
I'm about to finish my psychology thesis but something bugs me off.
In some part of the thesis, i analyze the time period which the subjects go to bed at.
The problem : My graph does not understand that a 11PM bedtime is BEFORE a 01AM bedtime.
Excel reads my data by stating that in one day, 11PM would be after 01AM. Which is true.
But in my case, 11PM is BEFORE 01AM because there is 2 seperate days going on.
Can you please help me ?
Oct 03 2021 03:47 AM
@louisEht Can you post a screenshot if the graph you are trying to create?
Oct 03 2021 04:03 AM
One possible solution is to add 1 (i.e. 24 hours) to bedtimes that are before midday.
Oct 03 2021 08:06 AM
Oct 03 2021 09:29 AM
This shows an additional data column with the 1 added to the early morning dates
Then a default line chart might become
Oct 03 2021 11:28 AM
SolutionCan you please put your excel sheet link?
Oct 03 2021 12:11 PM - edited Oct 03 2021 12:12 PM
I didn't save the file because it used the 365 RANDARRAY function that you may not have. I retrieved the unsaved file and substituted hard values in place of randomly generated data.
Oct 03 2021 11:28 AM
Solution