Power Query Listing of Files - Duration

[brawnystaff]

I am using Excel 2016 and the "Get and Transform" feature (Power Query) to list files in a folder. By default, it gives file name, extension, date created/modified, attributes, and folder path. I have a directory full of videos shot from a Go Pro. Is it possible to add a custom column that would give me the length of each video file (run time)? Thanks.

 

[MarcelBeug]

I guess the closest you can get is using the file size.
In addition to the fields you mention, the file list also contains a column "Attributes" with records. If you expand this column, you can select field Size.
Suppose every 80,000,000 bytes represents about a minute of movie, estimated duration can be calculated as Duration.From([Size]/80000000/24/60).