Concatenate text and convert to numbers in Excel

I've an extended Excel file which hold the date, month, yr, hour, minute, and second in separate columns (determine 1). I need to use just one column to current the time, so it will be simpler to plot the time as x-axis. Right here is the perform I utilized in cell G2:

=VALUE(CONCATENATE(A2,"/",B2,"/",C2," ",D2,":",E2,":", F2))

The Worth perform convert the textual content into numbers.
The Concatenate perform connects all of the textual content and convert them into one string.

Concatenate text and convert to numbers in Excel

I have a long Excel file which keep the date, month, year, hour, minute, and second in separate columns (figure 1). I want to use only one column to present the time, so it would be easier to plot the time as x-axis. Here is the function I used in cell G2:

=VALUE(CONCATENATE(A2,"/",B2,"/",C2," ",D2,":",E2,":", F2))

The Value function convert the text into numbers.
The Concatenate function connects all the text and convert them into one string.