Time with Todays Date

[Neilesh Kumar]

Hi Experts,

Can you please help me that if i put time in a cell in excel then todays date and time with AM/PM automatically appears in? Request to you kindly help me out Experts.


Regards,

Neilesh

[Neil_]

Right click the cell, format cells, choose custom, apply this format
dd/mm/yyyy hh:mm AM/PM
Enter the formula =Now() into the cell
It will only change when the sheet is recalculated (whenever you make a change)

[Ash_Maverick]

To enter the current date and time, press Ctrl + ; which inserts a date, then press the Space key, and then hit Ctrl + Shift + ; to insert the current time.