Combining several columns into a single column date/time

[#1]

I have imported some data from our sql server and it brings in the dates and times in six different columns. I want to combine all these columns into a single date/time column for graphing purposes. Any insight into this would be greatly appreciated.

[#2]

The formula for you new column is

Date MDY(:Month,:Day,:Year)+:hour*3600+:Minute*60:Second;

[#3]

Thanks txnelson,  that worked perfectly.