Sep 06 2021 07:54 AM
I need to take the time of images that were taken by the camera and put them in excel, is there any formula?
or would i have to manually enter the schedules?
Sep 06 2021 08:21 AM - edited Sep 06 2021 08:40 AM
Unfortunately there is no such option.
To manipulate the properties of a file you need to use some sort of programming such as VBA or vbScript or PowerShell, etc.
Public Function GetTimeOfPicture(Picture As String) As Date
GetTimeOfPicture = Format(FileDateTime(Picture), "mm/dd/yyyy h:mm:ss")
End Function
For a comprehensive solution I suggest you check ExifTool