Time calculation in Infopath 2010 - InfoPath Dev
in

InfoPath Dev

Time calculation in Infopath 2010

Last post 11-10-2013 12:25 PM by wilkies0106aw. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 11-08-2013 07:28 AM

    Time calculation in Infopath 2010

    In Sharepoint I have a list created. In the list I have times in a drop-down list using this fomat: 8:30 AM

    I have seen posts without the AM/PM specification; however, I really want to use it.

    I use this calculation and it works beautifully in the Sharepoint list to calculate the amount of time between two times.  Where Sun1Out = Stop Time and Sun1in = Start Time.

    =((SunOut1-INT(SunOut1))*24)-((SunIn1-INT(SunIn1))*24)

     I am using Infopath 2010 to create my form but it will not take this calculation.  How should my formula be written in Infopath or what functions should I use?

    Thank you

  • 11-10-2013 12:25 PM In reply to

    Re: Time calculation in Infopath 2010

     If the calculation is already done in the SharePoint list, you could create a form load rule or a query for data rule to set the 'total' field as required.

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