SOLVED

SPO Modified column

%3CLINGO-SUB%20id%3D%22lingo-sub-2658445%22%20slang%3D%22en-US%22%3ESPO%20Modified%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2658445%22%20slang%3D%22en-US%22%3E%3CP%3ENeed%20Help%20please..%20i%20have%20an%20SPO%20with%20a%20calculated%20column%20to%20extract%20the%20time%20only%20from%20the%20modified%20column.%20im%20getting%20the%20the%20time%20value%20but%20for%20some%20reason%20the%20time%20that%20im%20getting%20is%20incorrect.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecan%20anyone%20please%20help%20me%20why%20is%20this%20happening%3F%20i%20have%20added%20a%20JSON%20syntax%20on%20my%20modified%20column%20to%20format%20the%20time%20and%20time%20to%20this%26nbsp%3B%3CSPAN%3E8%2F17%2F2021%2C%205%3A40%3A24%20PM%20instead%20of%20showing%20just%20%225hours%20ago%22%20or%20sometimes%20would%20show%20%22Yesterday%20at%209%3A00%20AM%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Ehere%20is%20my%20column%20example.%20im%20extracting%20the%20time%20from%20the%20%22last%20modified%22%20to%20the%20%22Completion%20time%22%20Column.%20the%20last%20modified%20time%20is%205%3A40PM%20but%20on%20my%20calculated%20column%20(Completion%20time)%20shows%2002%3A40PM.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Abbyamante_0-1629248377460.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303930i41A72FD96C5D4497%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Abbyamante_0-1629248377460.png%22%20alt%3D%22Abbyamante_0-1629248377460.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehere%20is%20my%20JSON%20syntax%20on%20the%20%22last%20modified%20column%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Abbyamante_1-1629248504023.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303931i266F3BDF5ACA361C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Abbyamante_1-1629248504023.png%22%20alt%3D%22Abbyamante_1-1629248504023.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CDIV%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSPAN%3Eand%20here%20is%20my%20format%20on%20the%20completion%20time%20column%26nbsp%3B%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Abbyamante_2-1629248541596.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303932iA326E856550C6E53%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Abbyamante_2-1629248541596.png%22%20alt%3D%22Abbyamante_2-1629248541596.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2658445%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2663223%22%20slang%3D%22en-US%22%3ERe%3A%20SPO%20Modified%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2663223%22%20slang%3D%22en-US%22%3EPlease%20disregard%20question%20above.%20i%20was%20able%20to%20resolved%20the%20issue.%20thank%20you%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Need Help please.. i have an SPO with a calculated column to extract the time only from the modified column. im getting the the time value but for some reason the time that im getting is incorrect. 

 

can anyone please help me why is this happening? i have added a JSON syntax on my modified column to format the time and time to this 8/17/2021, 5:40:24 PM instead of showing just "5hours ago" or sometimes would show "Yesterday at 9:00 AM"

 

here is my column example. im extracting the time from the "last modified" to the "Completion time" Column. the last modified time is 5:40PM but on my calculated column (Completion time) shows 02:40PM. 

 

Abbyamante_0-1629248377460.png

 

here is my JSON syntax on the "last modified column"

 

Abbyamante_1-1629248504023.png

 

and here is my format on the completion time column 

 

Abbyamante_2-1629248541596.png

 

please help!

1 Reply
best response confirmed by Abbyamante (Occasional Contributor)
Solution
Please disregard question above. i was able to resolved the issue. thank you