Time Calculation in InfoPath 2013 need help with the formula - InfoPath Dev
in

InfoPath Dev

Office365 Alert - Sandbox has been deprecated in SharePoint Online.
Read more here.

Having trouble finding a blog or post that answers your question? Check out our Custom Search Page

Time Calculation in InfoPath 2013 need help with the formula

Last post 03-20-2017 12:13 PM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-20-2017 11:35 AM

    • Sheila
    • Not Ranked
      Female
    • Joined on 10-08-2013
    • Boca Raton, FL
    • Posts 22

    Time Calculation in InfoPath 2013 need help with the formula

    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. 

  • 03-20-2017 12:13 PM In reply to

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

    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?
    Hilary Stoupa

Page 1 of 1 (2 items)
Copyright © 2003-2017 Qdabra Software. All rights reserved.
View our Terms of Use.