Keep number format after converting time to text

I want to use the =right(cell, number of characters) function with time data,
but when I do this, it first ratios the numbers and then gives me the wrong
answer.
For example:

8:33 =right(a1,2) I want it to return 33, but instead returns 25
8:34 =right(a2,2) I want it to return 34, but instead returns 44
8:35 =right(a3,2) I want it to return 35, but instead returns 89

I have tried formatting the cells from time to text, but when I do, it
calculates the ratio or something. Is there another format or conversion I
can use?

DH

Try

=RIGHT(TEXT(A1,"hh:mm"),2)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DH" <[email protected]> wrote in message
news:[email protected]...
> I want to use the =right(cell, number of characters) function with time
data,
> but when I do this, it first ratios the numbers and then gives me the
wrong
> answer.
> For example:
>
> 8:33 =right(a1,2) I want it to return 33, but instead returns 25
> 8:34 =right(a2,2) I want it to return 34, but instead returns 44
> 8:35 =right(a3,2) I want it to return 35, but instead returns 89
>
> I have tried formatting the cells from time to text, but when I do, it
> calculates the ratio or something. Is there another format or conversion
I
> can use?
>
> DH

The dificulty is that the cell you are referencing is formated for time
you might try
= minute(a1)

"DH" wrote:

> I want to use the =right(cell, number of characters) function with time data,
> but when I do this, it first ratios the numbers and then gives me the wrong
> answer.
> For example:
>
> 8:33 =right(a1,2) I want it to return 33, but instead returns 25
> 8:34 =right(a2,2) I want it to return 34, but instead returns 44
> 8:35 =right(a3,2) I want it to return 35, but instead returns 89
>
> I have tried formatting the cells from time to text, but when I do, it
> calculates the ratio or something. Is there another format or conversion I
> can use?
>
> DH