I want to take the solution to a simple arithmetic formula, say 90/18, and
have it output as a value in minutes. I have been unable to figure this one
out. In my spreadsheet, I want the answer for 90/18 to be :05. However, all
the time functions that I have utilized (timevalue, minute, text (x, ":mm") )
are all giving me a value of :01.

Does anyone know how to make that integer display as that number of minutes?

Thanks in advance.

Hi

Divide by 1440 and format as time.

HTH. Best wishes Harald

"Solidarity1" wrote in message
...
I want to take the solution to a simple arithmetic formula, say 90/18, and
have it output as a value in minutes. I have been unable to figure this
one
out. In my spreadsheet, I want the answer for 90/18 to be :05. However,
all
the time functions that I have utilized (timevalue, minute, text (x,
":mm") )
are all giving me a value of :01.

Does anyone know how to make that integer display as that number of
minutes?

Thanks in advance.

Assuming the 90 & 18 are integers, format your cell as time (as desired).
=A1/A2/(24*60)
--
John C


"Solidarity1" wrote:

I want to take the solution to a simple arithmetic formula, say 90/18, and
have it output as a value in minutes. I have been unable to figure this one
out. In my spreadsheet, I want the answer for 90/18 to be :05. However, all
the time functions that I have utilized (timevalue, minute, text (x, ":mm") )
are all giving me a value of :01.

Does anyone know how to make that integer display as that number of minutes?

Thanks in advance.

Excel stores dates and time as real numbers. Portion after the decimal stores
the time part

if you enter the following in a cell
=1/(24*60*60)
and format that cell as h:mm:ss
then you will see
0:00:01 that is one minute past midnight of 1/1/1900

So to convert any number into minutes divide it by 24*60*60 and format the
cell as h:mm:ss

In your example it will be
=(90/18)/(24*60*60)

So

"Solidarity1" wrote:

I want to take the solution to a simple arithmetic formula, say 90/18, and
have it output as a value in minutes. I have been unable to figure this one
out. In my spreadsheet, I want the answer for 90/18 to be :05. However, all
the time functions that I have utilized (timevalue, minute, text (x, ":mm") )
are all giving me a value of :01.

Does anyone know how to make that integer display as that number of minutes?

Thanks in advance.

Actually, the example you gave is 1 second past midnight, not 1 minute. You
only need to divide by (24*60) to conver to minutes.
--
John C


"Sheeloo" wrote:

Excel stores dates and time as real numbers. Portion after the decimal stores
the time part

if you enter the following in a cell
=1/(24*60*60)
and format that cell as h:mm:ss
then you will see
0:00:01 that is one minute past midnight of 1/1/1900

So to convert any number into minutes divide it by 24*60*60 and format the
cell as h:mm:ss

In your example it will be
=(90/18)/(24*60*60)

So

"Solidarity1" wrote:

I want to take the solution to a simple arithmetic formula, say 90/18, and
have it output as a value in minutes. I have been unable to figure this one
out. In my spreadsheet, I want the answer for 90/18 to be :05. However, all
the time functions that I have utilized (timevalue, minute, text (x, ":mm") )
are all giving me a value of :01.

Does anyone know how to make that integer display as that number of minutes?

Thanks in advance.

Thanks John,

That was a typo on my part... You are right - dividing by (24*60) will
convert to minutes...

"John C" wrote:

Actually, the example you gave is 1 second past midnight, not 1 minute. You
only need to divide by (24*60) to conver to minutes.
--
John C


"Sheeloo" wrote:

Excel stores dates and time as real numbers. Portion after the decimal stores
the time part

if you enter the following in a cell
=1/(24*60*60)
and format that cell as h:mm:ss
then you will see
0:00:01 that is one minute past midnight of 1/1/1900

So to convert any number into minutes divide it by 24*60*60 and format the
cell as h:mm:ss

In your example it will be
=(90/18)/(24*60*60)

So

"Solidarity1" wrote:

I want to take the solution to a simple arithmetic formula, say 90/18, and
have it output as a value in minutes. I have been unable to figure this one
out. In my spreadsheet, I want the answer for 90/18 to be :05. However, all
the time functions that I have utilized (timevalue, minute, text (x, ":mm") )
are all giving me a value of :01.

Does anyone know how to make that integer display as that number of minutes?

Thanks in advance.