Forum Discussion
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.
How to change the value of my cells to make the numbers in minutes stay ?
Thank you
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.
2 Replies
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 !!
