Convert string to a epoch time in Excel
datetime, epoch, excel
Solution
This will convert your date into somethign Excel will understand, If you have your date in Cell A1, Then convert that into Epoch Time
=(DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2)) + TIME(MID(A1,10,2),MID(A1,12,2),MID(A1,14,2))-25569)*86400)
Problem
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.