Last Modified with Time?

[lgsikaffy]

Hello everyone!

I have the following macro:

Function LastModified() As Date
Application.Volatile
LastModified = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")
End Function

And cell is "=LastModified()"

Is there a way to have the time in it?

so it would be 2/27/2019 12:00 pm?

[Haluk]

Just select cell B4 and apply a Time format to show both date and time.

[lgsikaffy]

Thank you Haluk!