InfoPath Dev

I've been tasked with calculating the difference between two DateTime fields and I'm surprised how complicated it is.  I have found many great codeless solutions but not quite what I need... Either days or hours, but I need to know the difference in days, hours and minutes.

StartTime
EndTime
Duration

I don't care what format the duration is in... Preferably a format that makes sense... Like "# Days, # Hours, # Minutes"

I've not got IP or SP to hand. Yet in excel you can work out what you want as follows using the following formula which you could try to see if it would work in a calculated column.

B2 is your End Date and Time, A2 is your start Date and Time.

=INT(B2-A2)&" days "&TEXT(B2-A2,"h"" hrs ""m"" mins ""s""secs""")

It assume that your original time in "A/B 2s" are in the following format: dd/mm/yyyy hh:mm:ss

If not crack open Excel and work with the formula and others. If you can do it in excel you can normally find a similar way to do it in InfoPath if used with SharePoint.

 Just checked and the above formula does work in my test environment. as a calculated column :)

 I... really don't understand.  If I was using SharePoint I could calculate it with calculated field value, but I'm asking how to do it in InfoPath.  I don't see how I can use an Excel formula in InfoPath.

 Anybody else have some suggestions?

I have attached a sample form for you.

It calculates Days/Hours/Minutes.

You should be able to pull what you need from it.  All of the fields are calcuated with formulas except for the Start Date and End Date.
I left everything used to calculate the time shown.  You can preview the form and see how it works.