Concatenate & show HH:mm - as a time format

[Smokeyham]

Hello,

I have a spreadsheet which calculates the median time. I want to concatenate this with some text.

The desired end result might read "Median time is 00:15" - meaning 0 hours and 15 minutes.

I am using the following formula
=Analysis!A2&" "&Analysis!B2&" minutes"

Where......
Analysis!A2 contains the text "Median time is"
Analysis!B2 contains the calculated value "00:15"

The problem I run across is that the concatenated result of my formula =Analysis!A2&" "&Analysis!B2&" minutes" is the following:

Median time is 0.014659870321 minutes

In the calculated cell (Analysis!B2) the value shows up just fine (00:15). The problem I have is when I concatenate this.

I've tried using a text function "&text(Analysis!B2,00:00) but I get an error message.

Any help would be appreciated.

Thanks.

Gordon

 

[Smitty]

Looks like you're missing some apostrophes and have the wrong format:

=Analysis!A2&TEXT(Analysis!B2," hh:mm")

Hope that helps,

 

[lenze]

=Analysis!A2&" "&Analysis!TEXT(B2,"hh:mm") &" minutes"

But why not just Custom Format your cell(B2)?
"Median Time is "hh:mm" minutes"

lenze

 

[Smokeyham]

Looks like you're missing some apostrophes and have the wrong format:

=Analysis!A2&TEXT(Analysis!B2," hh:mm")

Hope that helps,

Just what I needed!! Thanks so much.

Gordon