Forum Discussion

Emmad60's avatar
Emmad60
Copper Contributor
Jun 07, 2021
Solved

Modify cells

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. H...
  • HansVogelaar's avatar
    Jun 07, 2021

    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.

Resources