+ Reply to Thread
Results 1 to 3 of 3

Replicating a custom formatted cell in a concatenated formula! I think!

  1. #1
    Registered User
    Join Date
    05-28-2010
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    75

    Replicating a custom formatted cell in a concatenated formula! I think!

    Hi - I have a cell which has a time in it hh:mm format

    I want the time to appear on another line but amongst other data (in different formats) which has been concatenated

    Hope the attachment works

    Hope you can help

    Thanks as always - Paul

    Excel Forum - Hours Value.xlsx

  2. #2
    Registered User
    Join Date
    08-27-2012
    Location
    France
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Replicating a custom formatted cell in a concatenated formula! I think!

    Hi,

    May be with this formula:

    Please Login or Register  to view this content.
    Hope it will help you,

    m

  3. #3
    Registered User
    Join Date
    05-28-2010
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    75

    Re: Replicating a custom formatted cell in a concatenated formula! I think!

    thanks mth - nearly worked - just replace the ; with a , and I'm sorted - thanks again!

    ="Shift 0:00 to "&TEXT(E8,"hh:mm")&" and "&TEXT(F8,"hh:mm")&" to 0:00 at "&A8

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1