検索
検索

convert text string to date/time format

debugcn 投稿 Dev
7
roman_bull

I have a column that is text formatted like 20110408_2041. How can I format it to date/time format?

W_Whalley

Assuming that your string is coded YYYMMDD_HHMM for Year, Month, Day, Hour, Minute, then you can construct an Excel formula to generate a cell in date/time format.

If the string is in cell A1, then this formula ought to do it:

=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))+TIME(MID(A1,10,2),RIGHT(A1,2),0)

You will need to format the cell properly to see the time portion. This is tested in LibreOffice calc, but Excel appears to have the same functions.

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]

編集
0

コメントを追加

0
サインイン

関連記事

分類Dev

How to convert string data with variable format to datetime?

分類Dev

Convert a specific format dateTime string to DateTime in C#

分類Dev

SQL DateTime Format Convert

分類Dev

How to convert DateTime to a String

分類Dev

Convert string to datetime to epoch

分類Dev

How do I convert a Calendar object to an ISO 8601 format DateTime string?

分類Dev

Format DateTime to local string with a timezone

分類Dev

Format DateTime without string conversion

分類Dev

convert python datetime with timezone to string

分類Dev

Convert string to datetime - python dataframe

分類Dev

Java Convert String into datetime Object

分類Dev

Convert HTML data into Text format

分類Dev

Excel text to convert date format

分類Dev

PHP: Convert epoch to MySQL DateTime format

分類Dev

How to convert a datetime format to minutes - pandas

分類Dev

How to convert a column with null values to datetime format?

分類Dev

When is empty string "" a valid DateTime string format?

分類Dev

String date format convert to date

分類Dev

Convert date format to string in Pandas

分類Dev

Convert string into an array with certain format

分類Dev

String.Format（）TimeSpanとDateTime

分類Dev

String.format() DateTime With Arabic culture

分類Dev

android string datetime format with month and day

分類Dev

PHP: Convert String to DATETIME with Consideration of am/pm

分類Dev

Ruby on Rails - Convert String to a DateTime action

分類Dev

Convert text/string response to html

分類Dev

Convert text to string array with separator

分類Dev

Using pd.to_datetime to convert int with format HHMMSS

分類Dev

How to convert to datetime if the format of dates changes gradually through the column?

Related 関連記事

  1. 1

    How to convert string data with variable format to datetime?

  2. 2

    Convert a specific format dateTime string to DateTime in C#

  3. 3

    SQL DateTime Format Convert

  4. 4

    How to convert DateTime to a String

  5. 5

    Convert string to datetime to epoch

  6. 6

    How do I convert a Calendar object to an ISO 8601 format DateTime string?

  7. 7

    Format DateTime to local string with a timezone

  8. 8

    Format DateTime without string conversion

  9. 9

    convert python datetime with timezone to string

  10. 10

    Convert string to datetime - python dataframe

  11. 11

    Java Convert String into datetime Object

  12. 12

    Convert HTML data into Text format

  13. 13

    Excel text to convert date format

  14. 14

    PHP: Convert epoch to MySQL DateTime format

  15. 15

    How to convert a datetime format to minutes - pandas

  16. 16

    How to convert a column with null values to datetime format?

  17. 17

    When is empty string "" a valid DateTime string format?

  18. 18

    String date format convert to date

  19. 19

    Convert date format to string in Pandas

  20. 20

    Convert string into an array with certain format

  21. 21

    String.Format（）TimeSpanとDateTime

  22. 22

    String.format() DateTime With Arabic culture

  23. 23

    android string datetime format with month and day

  24. 24

    PHP: Convert String to DATETIME with Consideration of am/pm

  25. 25

    Ruby on Rails - Convert String to a DateTime action

  26. 26

    Convert text/string response to html

  27. 27

    Convert text to string array with separator

  28. 28

    Using pd.to_datetime to convert int with format HHMMSS

  29. 29

    How to convert to datetime if the format of dates changes gradually through the column?

ホットタグ

アーカイブ