Modify cells

[Emmad60]

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 · Accepted 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.

[#3]

Thank you !!