Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Converting to Time Format
Hello,
I have imported a report from Notepad into Excel. There is a column that has various times in it, which I brought in as text (since I didn't have any other options). I now want to sort by time, and have the time be in ascending order. How can I change the format of this to time, so that Excel recognizes it as time, and sorts it correctly. Is there some kind of formula I can use? Thank you |
#2
|
|||
|
|||
Add a helper column. Add the formula
=A1*1 copy down, and sort on the helper column. -- HTH Bob Phillips "Amber" wrote in message ... Hello, I have imported a report from Notepad into Excel. There is a column that has various times in it, which I brought in as text (since I didn't have any other options). I now want to sort by time, and have the time be in ascending order. How can I change the format of this to time, so that Excel recognizes it as time, and sorts it correctly. Is there some kind of formula I can use? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting sum of time | Excel Worksheet Functions | |||
How to format elapsed time for swimming scores | Charts and Charting in Excel | |||
Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) | |||
Subtracting time in date format | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions |