--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