Hi all,

I have 2 questions really but hey are related to the same problem.

The problem is that i need to calculate the number of hours between 2 dates/times. I have been given the worksheet which has the 4 columns.
col1 = start date, col2 = start time, col3 = end date, col 4 = end time.

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.

2) And secondly i need to then work hours the total number of hours between the two dates excluding weekends??

Can anybody help on either problem? Many thanks in advance.