Modify cells

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



2 Replies
best response confirmed by Emmad60 (New Contributor)

@Emmad60 Use formulas to convert the fractions to minutes.

In B1402:




Fill down (and up if necessary).

Use column B in SPSS instead of column A.

Thank you !!