Ability to concatenate down to the HH:MM:SS

rwilkes

I've concatenated cells (in Figure 1) by using the formula in Figure 2 (MM stands for Month in my formula), which gives me a viable date (see Figure 3) to work with in SS. However, I want to go down to at least the minute. Is there another formula that can reach down to the hour & minute, or is (DATE(YYYY,MM,DD) the only way to form a date (=DATE(77, 8, 30, 3, 55) does not work… :(

7 | 29 | 26 | 7 | 25 |

Figure 1

=DATE(VALUE(YYYY@row), VALUE(MM@row), VALUE(DD@row))

Figure 2

07/29/26

Figure 3

Paul Newcome

The DATE function is the only way to form a date. You can add hours and minutes by "adding" them after the date, but this turns the outut into a text string that will not be recognized as a date.

=DATE(VALUE(YYYY@row), VALUE(MM@row), VALUE(DD@row)) + " " + HH@row + ":" + MM@row