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"