- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Need excel help - automate text to date time format
Posted on 6/1/23 at 12:58 pm to castorinho
Posted on 6/1/23 at 12:58 pm to castorinho
There is an issue with your format for the dataset. You need a comma.
Thu Jun 1, 2023 09:49:47 for instance
Then you can use this to get what you want
=DAYS(NOW(),RIGHT(LEFT(A1,FIND(":",A1)-4),LEN(LEFT(A1,FIND(":",A1)-4))-FIND(" ",LEFT(A1,FIND(":",A1)-4))))
If you cannot easily add the comma, I can get add something to do that as well.
Thu Jun 1, 2023 09:49:47 for instance
Then you can use this to get what you want
=DAYS(NOW(),RIGHT(LEFT(A1,FIND(":",A1)-4),LEN(LEFT(A1,FIND(":",A1)-4))-FIND(" ",LEFT(A1,FIND(":",A1)-4))))
If you cannot easily add the comma, I can get add something to do that as well.
Popular
Back to top
Follow TigerDroppings for LSU Football News