How to successfully convert time in Excel cell

Posted on 2014-08-20
Last Modified: 2014-08-20
 I have some start and end times in an excel spreadsheet that are written in 24hour clock, but with a colon between the hours and the minutes.  I have tried using the format cells option, and that does not work.  I need to successfully convert Cell to how the  AM or PM with the time so that whenever the spreadsheet is sorted, items counted, etc , the formulas used to convert the time will not cause additional issues.  I have attached an example spreadsheet.  Please assist.  Thank you.
Question by:mtrout
    LVL 23

    Accepted Solution

    Select column C, go to Data|Text to Columns, then skip to 3rd window.  Select Date in the "column Data format" section and click Finish.  Repeat for column D.

    Now select columns C:D and right click, then Format Cells, select Time from the Number tab, select the format you want (i.e. 1:30 PM).
    LVL 27

    Expert Comment

    by:Glenn Ray
    {redacted my answer}  ^ That is a cool solution, NBVC.

    Author Closing Comment

    Hello  NBVC,

    Thank you so, very, very much!!!  I really appreciate it.  This worked.  I Really appreciate the assistance.  Thank you again.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    To stay competitive, modern businesses must adapt and stay innovative, and this is increasingly only possible by working with outside talent. Managers and executives have understood the power of outsourcing for quite some time, but traditional clien…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now