strange timestamp format

[samuel_brierley]

hi all,

I'm working with an api that outputs a timestamp in the below formula. does anyone know how I might get the time and date out in the following formats?

current timestamp format: Fri Oct 02 13:01:18 +0000 2015

desired date format: DD/MM/YYYY

desired time format: hh:mm:ss

cheers all

[MK_QSL · Accepted solution]

=Date(Date#(MID('Fri Oct 02 13:01:18 +0000 2015',5,3) &  MID('Fri Oct 02 13:01:18 +0000 2015',9,2) & Right('Fri Oct 02 13:01:18 +0000 2015',4),'MMMDDYYYY'),'DD/MM/YYYY')

=Time(Time#(MID('Fri Oct 02 13:01:18 +0000 2015',12,8),'hh:mm:ss'))