Newbie Questions

Re: Formula needed for calculating total time when process is interrupted

Clay Fox — Wed, 02 Jul 2008 05:37:03 GMT

There is probably some script for datediff of time to calculate it natively.

I do not think InfoPath can calculate time difference natively.

I would think you would have to use string functions to parse the hours and minutes seperately and then do math comparisons and then you concat to recreate a time value in the correct format.

Re: Formula needed for calculating total time when process is interrupted

Anuma — Wed, 02 Jul 2008 05:36:21 GMT

Hi,

Can you please verify the below link.

http://blogs.msdn.com/infopath/archive/2007/02/21/calculating-elapsed-time-without-code.aspx

Formula needed for calculating total time when process is interrupted

infopath — Wed, 02 Jul 2008 02:46:44 GMT

In creating a form with calculated time ffields, I am having a problem.

I have five time fields that I am working with:

Begin process
Process interruption
Process resume
End process
Total time for process to run

Data is entered into fields 1 - 4 and I need to calculate the Total time (field 5). All fields are formatted to time fields with the time being displayed to appear as 8:47, 11:12, 11:47, 3:13. Every formula I try verifies as being a correct one, but the trial of data entry produces an "NaN" result.

Can anyone suggest a formula or expression for this?

Any help would be appreciated.

Thank you.