--history usage
Ralph Corderoy
ralph at inputplus.co.uk
Thu Nov 9 06:20:52 PST 2017
Hi Richard,
> I eventually found it was a Unix Epoch Timestamp, the number of
> seconds since 1 January 1970. It can be converted to a date by
> formatting a cell containing =(((E1/60)/60)/24)+DATE(1970,1,1) as a
> date.
Yes, that works most of the time and is good enough.
I think the seconds-since-epoch time in the file is GMT, i.e. +0000.
And it doesn't have any leap seconds. :-)
--
Cheers, Ralph.
https://plus.google.com/+RalphCorderoy
More information about the get_iplayer
mailing list