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 _______________________________________________ get_iplayer mailing list [email protected] http://lists.infradead.org/mailman/listinfo/get_iplayer
