I have some video files captured automatically and given file names
which must be date/times. Here are a couple of examples:

1550820358.MOV was captured at about 07:25 on 22nd Feb 2019.
1550823001.MOV was captured at about 08:10 on the same morning (today).

So they must be in seconds from some base date. To avoid reinventing
this particular wheel, could someone kindly share a formula and/or VBA
macro that would convert those numbers to a date and time in my
favourite format please.

IOW, convert 1550820358 to 20190222-072558, i.e. just before 7:26 am on
22nd February 2019.

Terry, East Grinstead, UK

Hi Terry,

Am Fri, 22 Feb 2019 09:20:30 +0000 schrieb Terry Pinnell:

I have some video files captured automatically and given file names
which must be date/times. Here are a couple of examples:

1550820358.MOV was captured at about 07:25 on 22nd Feb 2019.
1550823001.MOV was captured at about 08:10 on the same morning (today).

So they must be in seconds from some base date. To avoid reinventing
this particular wheel, could someone kindly share a formula and/or VBA
macro that would convert those numbers to a date and time in my
favourite format please.

IOW, convert 1550820358 to 20190222-072558, i.e. just before 7:26 am on
22nd February 2019.

1550820358.MOV in A1. Then:
=DATE(1970,1,1)+LEFT(A1,LEN(A1)-4)/86400


Regards
Claus B.
--
Windows10
Office 2016

Claus Busch wrote:

=DATE(1970,1,1)+LEFT(A1,LEN(A1)-4)/86400

Excellent, thanks Claus!

Best wishes,

Terry, East Grinstead, UK