Re: Time Calculation in InfoPath 2013 need help with the formula

Hilary Stoupa — Mon, 20 Mar 2017 19:13:33 GMT

So - this formula is for a calculated list column. That is, the formula goes into a computed column type in SharePoint. Is that where you are putting it? Or are you putting this in an InfoPath formula?

Time Calculation in InfoPath 2013 need help with the formula

Sheila — Mon, 20 Mar 2017 18:35:27 GMT

I have a formula that I found online and I am not coder so I don't know if this is correct or not but I took the code and am getting errors right off the bat. Can someone look at this and tell me what's wrong with it?

Here is the full string:

=CONCATENATE(TEXT(HOUR([Finish Time]-[Arrival Time]),"#"),":",TEXT(MINUTE([Finish Time]-[Arrival Time]), "#"))

I have a date/time field called Arrival Time and one called Finish Time. I have a text field (according to the article) that I am trying to set the above formula as it's default value. I have also tried using a rule where Finish Time is not blank then run this formula. But the formula itself errors out starting with telling me that the brackets are not correct, I take out the brackets and then it goes to the work HOUR.

I am working in a SP Online list and just need to do a finish time - start time. Not sure if it will always be within 24 hours but pretty sure it will, so I don't need to worry about that, unless there is an easy way to add this.

Thank you.

General

Re: Time Calculation in InfoPath 2013 need help with the formula

Time Calculation in InfoPath 2013 need help with the formula