Timd/date format question

[mikecox39]

When I rt click a column or cell and set the format for time and date and enter [4-25] I get [1/13/1900 12:00:00 AM] in the address field and [4/25/19 0:00] in the cell.

First, why are the options grayed out; they seem to be working otherwise and is there a way to get the program to plug in the current time by default?

Also is it possible to enter just the time in a date/time formatted cell so that 1/0/00 doesn't display? The reason I ask is because I want the date to display in the first entry of the day, then just the time for the following entries of the day.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...nu-options-time-formated-delivers-0000-a.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).