View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Terry Pinnell[_4_] Terry Pinnell[_4_] is offline
external usenet poster
 
Posts: 192
Default Converting a date number?

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