I have a column with a date (which is an actual date) and a column with a
time (which is a text value). I wish to combine these as a signle date time
value and then add 14 hrs to this.

If my date is in A1 and my time is in B2 then what formula should I use in C1?

Bruce