SOLVED

Modify cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2421244%22%20slang%3D%22fr-FR%22%3EModify%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2421244%22%20slang%3D%22fr-FR%22%3E%3CP%3EHi%20there!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20big%20issue%20%3A%20i%20work%20on%20a%20database%20and%20my%20data%20are%20in%20minutes%20thanks%20to%20excel.%20When%20i%20upload%20them%20in%20SPSS%2C%20in%20only%20see%20numbers%20like%200%2C7347%20because%20the%20shape%20by%20excel%20is%20gone.%3C%2FP%3E%3CP%3EHow%20to%20change%20the%20value%20of%20my%20cells%20to%20make%20the%20numbers%20in%20minutes%20stay%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Emmad60_0-1623056807437.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F286784i0891A91BDE3DE9A5%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Emmad60_0-1623056807437.png%22%20alt%3D%22Emmad60_0-1623056807437.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2421244%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2421437%22%20slang%3D%22en-US%22%3ERe%3A%20Modify%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2421437%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1072632%22%20target%3D%22_blank%22%3E%40Emmad60%3C%2FA%3E%20Use%20formulas%20to%20convert%20the%20fractions%20to%20minutes.%3C%2FP%3E%0A%3CP%3EIn%20B1402%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3D1440*A1402%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFill%20down%20(and%20up%20if%20necessary).%3C%2FP%3E%0A%3CP%3EUse%20column%20B%20in%20SPSS%20instead%20of%20column%20A.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi there !

 

I have a big issue : i work on a database and my data are in minutes thanks to excel. When i upload them in SPSS, in only see numbers like 0,7347 because the shape by excel is gone.

How to change the value of my cells to make the numbers in minutes stay ? 

 

Thank you

Emmad60_0-1623056807437.png

 

2 Replies
best response confirmed by Emmad60 (New Contributor)
Solution

@Emmad60 Use formulas to convert the fractions to minutes.

In B1402:

 

=1440*A1402

 

Fill down (and up if necessary).

Use column B in SPSS instead of column A.

Thank you !!