I have 1 field - Plan_Depart_Date that is a date picker field
formatted with no time,
1 field that is a 2 character text field that is for the user to input
an Hr (in military time)
1 field that is a 2 character text field that is for the user to input
a Mn (in miliaray time)

I have a rule set on the Minute field if that a date is present in the
Plan_Depart_Date and a Min is present to set the value on a 4th
Plan_Depart_Time (Date time) field to

concat(substring(@Planned_Departing_Date, 6, 2), "-",
(substring(@Planned_Departing_Date, 9, 2)), "-",
(substring(@Planned_Departing_Date, 1, 4)), " ", @P_Depart_Time_Hr,
":", ., ":00")

Its coming out like this
10-2-2007 24:13:00 and is giving an invalid date message.  I need it
to come out as a valid date/Time and looking like this
10-2-2007 11:13 PM.

I've tried a number of variations to get this and I have had no luck.
Does anyone know the secret answer?