=CONCATENATE (date/time) to work with =NETWORKDAY

In the attached workbook, is there a way to CONCATENATE the date and time (columns (C,D / E,F / H,I) into a format that will work with NETWORKDAY?
Any help is greatly appreciated!
Sick

Columns D,F and I are text

Use this to convert to time, then you can use the NETWORKDAYS formula

=LEFT(D3,LEN(D3)-2)&" "&RIGHT(D3,2)

Networkdays (and workday) don't use time anyway, so the time cells are irrelevant to networkdays.
The result of networkdays will be the same regardless of the time of each date.
So you can just use the Dates in C E and H by themselves without the times.

If the times are important in some way, can you explain in words what you're trying to accomplish?

Can I reformat D,F and I into time?

just formatting wont help, as Excel will still read it as text. You will need to coerce it into becoming a time i.e. a number

Do I concantenate the date and time or is there a way to use seperate cells in networkday

Lets says you want to find NETWORKDAYS between template date/time and CAD date/time use
=NETWORKDAYS(C3+(LEFT(D3,LEN(D3)-2)&" "&RIGHT(D3,2))*1,E3+(LEFT(F3,LEN(F3)-2)&" "&RIGHT(F3,2))*1)

Having said that, the NETWORKDAYS calculation does not tae into account the time, you can skip it altogether
Hence,
=NETWORKDAYS(C3,E3)

In that case

=C3+(LEFT(D3,LEN(D3)-2)&" "&RIGHT(D3,2))*1-(E3+(LEFT(F3,LEN(F3)-2)&" "&RIGHT(F3,2))*1))

Format as dd/hh/mm