try a format of:
"[hh]:mm"

instead of:
"hhh:mm"

JR wrote:

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) ,"hhh:mm") but it is
returning 1:00, when the return should be 433:00.

Thanks for your help.

"Peo Sjoblom" wrote:

Just format as mm:ss

or if you don't mind if it is text


=TEXT(perform_dump!B35/24/60,"mm"ss")

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"JR" wrote in message
...
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?

Thanks





--

Dave Peterson