show time

  1. Smokeyham

    Concatenate & show HH:mm - as a time format

    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...

Some videos you may like

This Week's Hot Topics