Julian date and time conversion.

[nmccracken]

Having some problems getting the correct month and days to populate.
Does anyone have a good formula to convert a 4 digit Julian date and copy the time over from one cell to the adjacent cell.

data I have: 2182/0950 (yddd/hhmm)
conversion I am trying to achieve: 1 July/0950

 

[igold]

Welcome to the MrExcel Forum. What about this, where your data is in Cell A1. Assuming all data will be for the year 2022.

=TEXT((DATE(2021,12,31)+MID(A1,2,3)),"d mmmm")&RIGHT(A1,5)

 

[Dave Patton]

If you require Date and Time , custom format the following to your preference.

Date and Time 2021.xlsm
	A	B
3	2182/0950	01-Jul-22 09:50
4	2200/2230	19-Jul-22 10:30 PM
14b

Cell Formulas
Range	Formula
B3	B3	=DATE(2021,12,31)+MID(A3,2,3)+TEXT(RIGHT(A3,4),"00\:00")
B4	B4	=44561+MID(A4,2,3)+TEXT(RIGHT(A4,4),"00\:00")

 

[igold]

Did I mis-read or was this the output the OP was trying to achieve...

Book1.xlsm
	A	B
1	2182/0950	1 July/0950
2	2182/0951	1 July/0951
Sheet1

Cell Formulas
Range	Formula
B1:B2	B1	=TEXT((DATE(2021,12,31)+MID(A1,2,3)),"d mmmm")&RIGHT(A1,5)