-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Need Date format
- Thread starter Faraz5023
- Start date
etaf
Well-known Member
- Joined
- Oct 24, 2012
- Messages
- 8,378
- Office Version
- 365
- Platform
- MacOS
how is the data imported into the sheet
I suspect its been imported as text
if you format the cell as General - then you should see a number
45338.65347
you will also see if left justified , then text - if a real date - then right justified
is it JUST that 1 cell - I can provide a formula that you can put into another cell / cells to convert using text functions
what version of excel from the list you have in profile do you want to use
better just to have the version in the profile , you wish to use the solution with
I suspect its been imported as text
if you format the cell as General - then you should see a number
45338.65347
you will also see if left justified , then text - if a real date - then right justified
is it JUST that 1 cell - I can provide a formula that you can put into another cell / cells to convert using text functions
what version of excel from the list you have in profile do you want to use
better just to have the version in the profile , you wish to use the solution with
Upvote
0
Alex Blakenburg
MrExcel MVP
- Joined
- Feb 23, 2021
- Messages
- 8,250
- Office Version
- 365
- Platform
- Windows
You can give this a try:
| Book6 | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | Start Time | End Time | Start Time (converted) | End Time (converted) | ||
| 2 | Feb 16 2024 1:21AM | Feb 16 2024 3:41PM | 16/02/2024 01:21 | 16/02/2024 15:41 | ||
Sheet1 | ||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C2:D2 | C2 | =--(MID(A2,5,2)&"-"&LEFT(A2,3)&"-"&TRIM(MID(A2,7,5)))+REPLACE(TRIM(RIGHT(A2,7)),LEN(TRIM(RIGHT(A2,7)))-1,0," ") |
Upvote
0
