[Solved] Enter Date & Time With CONCATENATE

[CapCrockett]

I know how to enter a static date & time into one cell using Ctrl+ combinations, but is it possible to enter a static date & time using CONCATENATE?

If so, how?

[FJCC]

This

Code: Select all

=CONCATENATE("2021-06-24"; " ";"12:32:14")

returns a string that is interpreted as a date and time.
What are you trying to accomplish beyond your immediate questions?

[CapCrockett]

Thank you.

What are you trying to accomplish beyond your immediate questions?

The time remaining to an option's expiration.

[Villeroy]

A concatenation returns text. Text is useless.
=A1-NOW() returns the time remaning between the date/time in A1 and now.

Having a date (day number) in A1 and a time (fraction of a day) in B1, A1+B1-NOW() returns the time remaining.

[Tutorial] Ten concepts that every Calc user should know (applies similarly to all spreadsheet applications)

[CapCrockett]

Having a date (day number) in A1 and a time (fraction of a day) in B1, A1+B1-NOW() returns the time remaining."

Thank you. That should accomplish my requirement. I had not yet tried the other solution.