Time Difference in Repeating Table - InfoPath Dev
in

InfoPath Dev

Time Difference in Repeating Table

Last post 06-12-2005 11:08 AM by awillms. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 06-11-2005 09:00 PM

    • awillms
    • Not Ranked
    • Joined on 06-11-2005
    • USA
    • Posts 2

    Time Difference in Repeating Table

    I have created a repeating table to track consulting time for billing. This table contains the a date field, a BeginTime field, a EndTime field, a TotalHours field and a description of work field. I want the TotalHours field to automatically update after updating either the BeginTime or the EndTime fields. I found a solution at this web site: http://radio.weblogs.com/0131777/stories/2004/02/22/howTototalingValuesInARepeatingTable.html, but it only works when you update the EndTime field and it only computes the time difference in whole hours.

    Can anyone help me?
  • 06-12-2005 07:26 AM In reply to

    Re: Time Difference in Repeating Table

    Hello
    Welcome to the Forum!

    I'm guessing that you have function msoxd_timesheet_endtime::OnAfterChange(eventObj) but do you have this function for starttime also? Please add an onafterchange function which calls "updatehoursworked" and the total hours will change when start time is changed also.

    Shanthi
    InfoPathDev India
    Shanthi Reddy
  • 06-12-2005 11:08 AM In reply to

    • awillms
    • Not Ranked
    • Joined on 06-11-2005
    • USA
    • Posts 2

    Re: Time Difference in Repeating Table

    Actually that doesn't work the way the script is set up in the example on the web site. How do I refer to a specific field in the same row of the table?

    Also, I still have the problem of the script only computing the time difference in whole hours. I need it to return partial hours - say the beginning time is 8:00 a.m. and the ending time is 9:15 a.m., I need it to return 1.25 for the total hours worked.

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