Image properties

Copper Contributor
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?

 

1 Reply

@Drosdowski 

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

ExifTool