Forum Discussion
How to put PM BEFORE 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 ?
Can you please put your excel sheet link?
6 Replies
This shows an additional data column with the 1 added to the early morning dates
Then a default line chart might become
Can you please put your excel sheet link?
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.
One possible solution is to add 1 (i.e. 24 hours) to bedtimes that are before midday.
louisEht Can you post a screenshot if the graph you are trying to create?
