I am trying to convert string in following format: 20130817T140000Z
(17th Aug 2013 at 14:00) to epoch time (seconds since 1970) in an MS Excel 2013.
Tried cell formatting, but it doesn't work with T
and Z
or the format in general.
I am trying to convert string in following format: 20130817T140000Z
(17th Aug 2013 at 14:00) to epoch time (seconds since 1970) in an MS Excel 2013.
Tried cell formatting, but it doesn't work with T
and Z
or the format in general.