Excel Magic Trick 312: Extract Date & Time From Text String
HTML-код
- Опубликовано: 22 авг 2024
- Download Excel Start File: people.highlin...
Download Excel file: people.highline...
Use the DATE, MID, LEFT, and TIME functions to extract dates and times from a database field that stores dates and times as a text string.
Dear roks7223,
The rule for data analysis and data extraction is; "recognize a pattern". In your example, if it is V you want, then you would build a formula to find V. If it was 1, then you would build a formula to find the 1. Always, when you are do data extraction, you have to look at all the data and find a pattern that was consistent.
Any answer comes from looking at all the data. What does all your data look like? What consistent pattern is there?
--excelisfun
Great trick which has saved so much time :)
Seconds are important to. I was watching this bat man cartoon were Tempest Fuget ( the clock king) said to his intern " It take aproximatly 2 minutes and thirty seconds to take these files to room 2a and back but it took you 5 minutes" and the intern was like "uh like I had to go to the bathroom" so he fliped out and fired him and went on a life long crime spree.
Saved me 👍😭
Hello,
Thanks for all these great videos. Can you help with the case where this is the data format?
Wed Mar 21 00:35:09 2012? Thanks much.
I am trying to do this in Libre Office Calc, however Libre Office doesn't appear to support the MMM Date Function, I keep getting #VALUE! Error.
Hi Excellsfun! Could you please help me find the formula in the next task? I have the date and time 06-11-2015 9:15:00 AM in cell A2 and I want to extract the day in text, so it should be Friday. Is this formula =TEXT(LEFT(A2,8),"dddd") correct?
08/01/2018 is being read by excel as Jan. 08,2018 instead of August 01,2018. How to fixed this?
What if date is like MMDDYYYY HH:MM THEN HOW CAN WE DO
04/09/2019 13:54:22 how to convert text date and text time to convert numbers
make this vedio sir