Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Greetings,
I have a Julian Date of 1326/2230 which I would need to be dispalyed as 22 Nov 2021 2230 and another example 1326/0025 which would be displayed as 22 Nov 2021 0025.
I'm thinkingI will have to use some sort of text to columns which will separate the date and time while droping the "/". Then I'll have to insert the first digit in front of the four numbes. After I get 1326 sepaeated I can add a 2 for all dates.
I do know
will get me the Calendar date from a 5 digit Julian Date , but I need this in a VBA for Column G.
I need someway of Concating the date and time- bear in mine I need to have the 24 clock. Soon as I remove the/ I loose all leading zeros.
Thank you,
I have a Julian Date of 1326/2230 which I would need to be dispalyed as 22 Nov 2021 2230 and another example 1326/0025 which would be displayed as 22 Nov 2021 0025.
I'm thinkingI will have to use some sort of text to columns which will separate the date and time while droping the "/". Then I'll have to insert the first digit in front of the four numbes. After I get 1326 sepaeated I can add a 2 for all dates.
VBA Code:
Sub test()
lastrow = Worksheets("Sheet1").Cells(Rows.Count, "F").End(xlUp).Row
For Each cell In Range("F1:F" & lastrow)
cell.Value = "2" & cell.Value
Next
End Sub
I do know
Excel Formula:
=DATE(IF(0+(LEFT(A1,2))<30,2000,1900)+LEFT(A1,2),1,RIGHT(A1,3))
I need someway of Concating the date and time- bear in mine I need to have the 24 clock. Soon as I remove the/ I loose all leading zeros.
Thank you,