Can someone please assist? I am given a J2000
time value. Using EXCEL formulas, I need to convert it to a normal date and time format like this:
- Example: Given
J2000 time = 430969629.999
- Answer should be:
08/28/2013 and 13:47:10
(military time).
Does anyone know the algorithms or EXCEL formulas for getting it?
If the J2000 time value is defined as seconds after noon 01/01/2000, then the following should work:
Formula in
B2
can be copied downwards to
B3
.Number format in
A2:A3
ismm/dd/yyyy hh:mm:ss
.