Image properties

%3CLINGO-SUB%20id%3D%22lingo-sub-2725133%22%20slang%3D%22en-US%22%3EImage%20properties%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2725133%22%20slang%3D%22en-US%22%3E%3CPRE%3E%3CSPAN%20class%3D%22Y2IQFc%22%3EI%20need%20to%20take%20the%20time%20of%20images%20that%20were%20taken%20by%20the%20camera%20and%20put%20them%20in%20excel%2C%20is%20there%20any%20formula%3F%0A%0Aor%20would%20i%20have%20to%20manually%20enter%20the%20schedules%3F%3C%2FSPAN%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2725133%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2725261%22%20slang%3D%22en-US%22%3ERe%3A%20Image%20properties%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2725261%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1148009%22%20target%3D%22_blank%22%3E%40Drosdowski%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%20there%20is%20no%20such%20option.%3CBR%20%2F%3ETo%20manipulate%20the%20properties%20of%20a%20file%20you%20need%20to%20use%20some%20sort%20of%20programming%20such%20as%20VBA%20or%20vbScript%20or%20PowerShell%2C%20etc.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3EPublic%20Function%20GetTimeOfPicture(Picture%20As%20String)%20As%20Date%0A%20%20%20%20GetTimeOfPicture%20%3D%20Format(FileDateTime(Picture)%2C%20%22mm%2Fdd%2Fyyyy%20h%3Amm%3Ass%22)%0AEnd%20Function%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2725345%22%20slang%3D%22en-US%22%3ERe%3A%20Image%20properties%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2725345%22%20slang%3D%22en-US%22%3EThank%20You%20For%20Posting%20Microsoft%20Community%20%2CWe%20are%20here%20to%20help%20you%20So%20call%20Microsoft%20Team%201-505-355-2241%2CLevel%205%20Support%20Team%20Will%20help%20you%20.%3C%2FLINGO-BODY%3E
Occasional Visitor
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