Adding time values from different tables - InfoPath Dev
in

InfoPath Dev

Adding time values from different tables

Last post 09-13-2015 10:22 PM by donstephen. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 09-03-2015 11:04 PM

    • vinayn
    • Not Ranked
    • Joined on 09-04-2015
    • Posts 1

    Adding time values from different tables

    Hi, First of all I would like to apologise as I am new here an not sure where to post my question, or whether this question has been asked/answered before ps. I am new to all of this My problem is that I am trying to write a web-based Infopath 2013 form which will be uploaded into Sharepoint online. The form is to be a timesheet for our staff. I have been able to complete all sections of the form, but I cannot seem to be able to have all the hours accumulated from the different days populate to a total somewhere else in the form. I have built the form within infopath 2013 based on the information provided via this link - http://blogs.msdn.com/b/infopath/archive/2007/02/21/calculating-elapsed-time-without-code.aspx this works well but I need different tables for each days, to allow for split shifts, and I cannot seem to understand how to make the total time populate from all tables (ie different days) Any help would be much appreciated I have attached a copy of my form if it helps. Thank you V.
  • 09-13-2015 10:22 PM In reply to

    Hi Vinayn,

    I have looked into your form and added some fields to get the total hours per day. The next step which you need to perfrom is to convert these time values into numbers, then sum the numbers and convert the result back into a time value.

    I hope I am able to point you toward the right direction.

    Regards,

    Don Stephen Lambatin / Support Engineer
    Qdabra Software
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.