SOLVED

How to put PM BEFORE AM

%3CLINGO-SUB%20id%3D%22lingo-sub-2806713%22%20slang%3D%22fr-FR%22%3EHow%20to%20put%20PM%20BEFORE%20AM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2806713%22%20slang%3D%22fr-FR%22%3E%3CP%3EHey%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20about%20to%20finish%20my%20psychology%20thesis%20but%20something%20bugs%20me%20off.%3C%2FP%3E%3CP%3EIn%20some%20part%20of%20the%20thesis%2C%20i%20analyze%20the%20time%20period%20which%20the%20subjects%20go%20to%20bed%20at.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20%3A%20My%20graph%20does%20not%20understand%20that%20a%2011PM%20bedtime%20is%20BEFORE%20a%2001AM%20bedtime.%3C%2FP%3E%3CP%3EExcel%20reads%20my%20data%20by%20stating%20that%20in%20one%20day%2C%2011PM%20would%20be%20after%2001AM.%20Which%20is%20true.%3C%2FP%3E%3CP%3EBut%20in%20my%20case%2C%2011PM%20is%20BEFORE%2001AM%20because%20there%20is%202%20seperate%20days%20going%20on.%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20help%20me%20%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2806713%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2806732%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20put%20PM%20BEFORE%20AM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2806732%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1173441%22%20target%3D%22_blank%22%3E%40louisEht%3C%2FA%3E%26nbsp%3BCan%20you%20post%20a%20screenshot%20if%20the%20graph%20you%20are%20trying%20to%20create%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2806737%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20put%20PM%20BEFORE%20AM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2806737%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1173441%22%20target%3D%22_blank%22%3E%40louisEht%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOne%20possible%20solution%20is%20to%20add%201%20(i.e.%2024%20hours)%20to%20bedtimes%20that%20are%20before%20midday.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2807024%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20put%20PM%20BEFORE%20AM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2807024%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1173441%22%20target%3D%22_blank%22%3E%40louisEht%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20illustrate%20above%20answer%2C%20just%20have%20similar%20file%20in%20collection%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20648px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F314671i19BF85F8B94A7280%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2807109%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20put%20PM%20BEFORE%20AM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2807109%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1173441%22%20target%3D%22_blank%22%3E%40louisEht%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20shows%20an%20additional%20data%20column%20with%20the%201%20added%20to%20the%20early%20morning%20dates%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20551px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F314675i38CE24892A981CBE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThen%20a%20default%20line%20chart%20might%20become%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20814px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F314676iB041889B5B1DD798%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 ? 

6 Replies

@louisEht Can you post a screenshot if the graph you are trying to create?

@louisEht 

One possible solution is to add 1 (i.e. 24 hours) to bedtimes that are before midday.

@louisEht 

To illustrate above answer, just have similar file in collection

image.png

@louisEht 

This shows an additional data column with the 1 added to the early morning dates

image.png

Then a default line chart might become

image.png

best response confirmed by louisEht (New Contributor)
Solution

@Peter Bartholomew

Can you please put your excel sheet link?

@louisEht 

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.