Time input

[Johnboy]

Hi All,

Question? When inputting a time only (11:30) in a cell Excel assumes the date to be 1/0/00, is there a way to input time only and have it assume today's date?

Thanks for all yor help
Johnboy

 

[Oaktree]

you could do =today() + A1

Where A1 has the time value.

Or, if you don't want the extra column:
1) put = today() in B1
2) Copy B1
3) Select the range of your times (i.e. the 11:30's)
4) Go to edit --> paste special --> values and check the "add" box.