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 |
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 |
All times are GMT +1. The time now is 05:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com