Two Column List of Minutes Told in a Fraction

Hi,

I would like to create two excel columns A and B. Column A would be the time equivalent in the form of a fraction of a whole. The Column B would contain the hour in minutes.

So using the example below, this chart would include all values from 0 to 60 minutes, and their equivalents in a fraction as represented in the example below (so column B would include all minutes from 0-60, such as 1, 2, 3, 41, 46, 59). There can be more than two digits after the decimal point in column A to represent the true fraction.

For example:

1.0 = 60 minutes
.75 = 45 minutes
.50 = 30 minutes
.25 = 15 minutes
.00 = 0 minutes

Thank you

Hoping this is what you need

minutes to fractions.xlsxSee file attached.

Thank you to both. I hit the star!

Simple way, if you need convert decimals in column in column B, just put

=A2*60

and dragged down

Thank you, starred.