[Webinar] Learn how to a build a cloud-first strategyRegister Now


How to successfully convert time in Excel cell

Posted on 2014-08-20
Medium Priority
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

NBVC earned 2000 total points
ID: 40274718
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
ID: 40274727
{redacted my answer}  ^ That is a cool solution, NBVC.

Author Closing Comment

ID: 40274741
Hello  NBVC,

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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Gain an elementary understanding of Blockchain technology.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

865 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