Hi Mrbrently,

I tried using =now() and a macro. Couldn't get the required result.
Any ideas?

sure, try

Sub Makro1()
Range("a1").NumberFormat = "dd/mm/yyyy hh:mm:ss"
Range("a1").Value = Now
End Sub

I think you just have the wrong number format in your sheet, add the
seconds :ss to your format.

regards

arno