I've gotten far evnough that I feel like I'm learning somthing but I'm still unsure about the end result. I now have the following formula retrning something.
(number(substring(txtEnd_Time, 12, 2)) * 3600 + number(substring(txtEnd_Time, 15, 2)) * 60 + number(substring(txtEnd_Time, 18, 2)) - (number(substring(txtDateTime, 12, 2)) ...