nmccracken
New Member
- Joined
- Jun 24, 2022
- Messages
- 1
- Office Version
- 365
- 2016
- Platform
- Windows
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
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