none
FORMAT TIME IN EXCEL RRS feed

  • Question

  • I have a  spreadsheet - one column holds the Hours and the other Minutes. Minutes don't include a leading zero, so I am trying to Concatenate them into a Time = G14 & ":" & IF( LEN( H14 = 1 ), "0" & H14, H14)

    G14 = Hrs H14 = minutes This formats correctly if the minutes are a single value (4:09) but not if the minutes are >1 (4:029)

    Tuesday, August 13, 2013 10:26 AM

Answers

  • Hi Dave,

    Here is a way to do set cells manually, please do like below:

    1-set data type for G14 and H14

    2-Set cell data type for I14 and see the test result.

    Hope it can help you.


    deny to access the Microsoft. build. evaluation.n project.

    Wednesday, August 14, 2013 12:56 PM