software

I would like to ask for help.

I have to convert a number 5.27 to time 5:16 as minutes and seconds. I am
using the following to convert: =perform_dump!B35/24/60, however the return
is showing an AM/PM and I just need minutes and seconds to I can run
variances.

Any solutions?

ThanksJust format as mm:ss

or if you don't mind if it is text=TEXT(perform_dump!B35/24/60,quot;mmquot;ssquot;)

--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;JRquot; gt; wrote in message
...
gt;I would like to ask for help.
gt;
gt; I have to convert a number 5.27 to time 5:16 as minutes and seconds. I am
gt; using the following to convert: =perform_dump!B35/24/60, however the
gt; return
gt; is showing an AM/PM and I just need minutes and seconds to I can run
gt; variances.
gt;
gt; Any solutions?
gt;
gt; Thanks
gt;
Format the cell using the format string

mm:ss

Do this by:
Formatgt;Cellsgt;Number amp; select Custom. Enter the string above in the Type boxquot;JRquot; wrote:

gt; I would like to ask for help.
gt;
gt; I have to convert a number 5.27 to time 5:16 as minutes and seconds. I am
gt; using the following to convert: =perform_dump!B35/24/60, however the return
gt; is showing an AM/PM and I just need minutes and seconds to I can run
gt; variances.
gt;
gt; Any solutions?
gt;
gt; Thanks
gt;

Peo,

I am receiving a quot;#VALUE!quot; I have added an extra quot; where it was missing.
Any thoughts

quot;Peo Sjoblomquot; wrote:

gt; Just format as mm:ss
gt;
gt; or if you don't mind if it is text
gt;
gt;
gt; =TEXT(perform_dump!B35/24/60,quot;mmquot;ssquot;)
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;JRquot; gt; wrote in message
gt; ...
gt; gt;I would like to ask for help.
gt; gt;
gt; gt; I have to convert a number 5.27 to time 5:16 as minutes and seconds. I am
gt; gt; using the following to convert: =perform_dump!B35/24/60, however the
gt; gt; return
gt; gt; is showing an AM/PM and I just need minutes and seconds to I can run
gt; gt; variances.
gt; gt;
gt; gt; Any solutions?
gt; gt;
gt; gt; Thanks
gt; gt;
gt;
gt;
gt;

I think I got it, it should look like this right:

=TEXT(perform_dump!B35/24/60,quot;mm:ssquot;)
quot;Peo Sjoblomquot; wrote:

gt; Just format as mm:ss
gt;
gt; or if you don't mind if it is text
gt;
gt;
gt; =TEXT(perform_dump!B35/24/60,quot;mmquot;ssquot;)
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;JRquot; gt; wrote in message
gt; ...
gt; gt;I would like to ask for help.
gt; gt;
gt; gt; I have to convert a number 5.27 to time 5:16 as minutes and seconds. I am
gt; gt; using the following to convert: =perform_dump!B35/24/60, however the
gt; gt; return
gt; gt; is showing an AM/PM and I just need minutes and seconds to I can run
gt; gt; variances.
gt; gt;
gt; gt; Any solutions?
gt; gt;
gt; gt; Thanks
gt; gt;
gt;
gt;
gt;

Correct

Peo

quot;JRquot; gt; wrote in message
...
gt;I think I got it, it should look like this right:
gt;
gt; =TEXT(perform_dump!B35/24/60,quot;mm:ssquot;)
gt;
gt;
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; Just format as mm:ss
gt;gt;
gt;gt; or if you don't mind if it is text
gt;gt;
gt;gt;
gt;gt; =TEXT(perform_dump!B35/24/60,quot;mmquot;ssquot;)
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; nwexcelsolutions.com
gt;gt;
gt;gt;
gt;gt; quot;JRquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I would like to ask for help.
gt;gt; gt;
gt;gt; gt; I have to convert a number 5.27 to time 5:16 as minutes and seconds. I
gt;gt; gt; am
gt;gt; gt; using the following to convert: =perform_dump!B35/24/60, however the
gt;gt; gt; return
gt;gt; gt; is showing an AM/PM and I just need minutes and seconds to I can run
gt;gt; gt; variances.
gt;gt; gt;
gt;gt; gt; Any solutions?
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
One more question

how do I use the same solutions when converting to text if the existing
formula is this: =VLOOKUP(BV1,Schedule_Dump!C130:I155,4,FALSE).

I tried using this:
=TEXT(VLOOKUP(BV1,Schedule_Dump!C130:I155,4,FALSE) ,quot;hhh:mmquot;) but it is
returning 1:00, when the return should be 433:00.

Thanks for your help.

quot;Peo Sjoblomquot; wrote:

gt; Just format as mm:ss
gt;
gt; or if you don't mind if it is text
gt;
gt;
gt; =TEXT(perform_dump!B35/24/60,quot;mmquot;ssquot;)
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;JRquot; gt; wrote in message
gt; ...
gt; gt;I would like to ask for help.
gt; gt;
gt; gt; I have to convert a number 5.27 to time 5:16 as minutes and seconds. I am
gt; gt; using the following to convert: =perform_dump!B35/24/60, however the
gt; gt; return
gt; gt; is showing an AM/PM and I just need minutes and seconds to I can run
gt; gt; variances.
gt; gt;
gt; gt; Any solutions?
gt; gt;
gt; gt; Thanks
gt; gt;
gt;
gt;
gt;

try a format of:
quot;[hh]:mmquot;

instead of:
quot;hhh:mmquot;

JR wrote:
gt;
gt; One more question
gt;
gt; how do I use the same solutions when converting to text if the existing
gt; formula is this: =VLOOKUP(BV1,Schedule_Dump!C130:I155,4,FALSE).
gt;
gt; I tried using this:
gt; =TEXT(VLOOKUP(BV1,Schedule_Dump!C130:I155,4,FALSE) ,quot;hhh:mmquot;) but it is
gt; returning 1:00, when the return should be 433:00.
gt;
gt; Thanks for your help.
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; Just format as mm:ss
gt; gt;
gt; gt; or if you don't mind if it is text
gt; gt;
gt; gt;
gt; gt; =TEXT(perform_dump!B35/24/60,quot;mmquot;ssquot;)
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; nwexcelsolutions.com
gt; gt;
gt; gt;
gt; gt; quot;JRquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I would like to ask for help.
gt; gt; gt;
gt; gt; gt; I have to convert a number 5.27 to time 5:16 as minutes and seconds. I am
gt; gt; gt; using the following to convert: =perform_dump!B35/24/60, however the
gt; gt; gt; return
gt; gt; gt; is showing an AM/PM and I just need minutes and seconds to I can run
gt; gt; gt; variances.
gt; gt; gt;
gt; gt; gt; Any solutions?
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson