1) So, the first problem is that i need to concatente the startdate/time and end date/time. When i try this however it converts them into the machine date/time. e.g. =a1 & " " & b1 (a1 = start date, b1 = start time) ...becomes 39448 0.375. Can i avoid this and show them as a date and time.
Right-click and format as date and time in the format you want