Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: How to convert Time to Text?

  1. #1
    New Member
    Join Date
    Oct 2007
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to convert Time to Text?

    I am looking for assistance in having one cell in a text format equals another cell that contains a time value in hh:mm format.

    For example: Cell A1 has a time format (hh:mm) value of 04:00; which is the Start Time. I would like cell D1 to have a text format value of "04:00" (result is dependant upon what is entered in A1). I would duplicate the same formulas to reflect Stop Times in other cells.

    My final result is to have another cell (F1) use the Concatenate formula to have the Start and Stop time shown in one cell as "04:00 - 12:30". The times would change based on the Time formated values entered into the Start and Stop time cells.

    I have researched this in the board and found many excellent ways to do the opposite, but not convert Time format to Text format. Any assistance is greatly appreciated.

    -Shane

  2. #2
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    7 Thread(s)

    Default Re: How to convert Time to Text?

    =TEXT(A1,"hh:mm")

    will convert the time in A1 to text.

  3. #3
    New Member
    Join Date
    Oct 2007
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Smile Re: How to convert Time to Text?

    Thank you! I was trying that with "00:00" instead of "hh:mm".

    Was mislead by Excel Help. Thank you for your clarity.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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