Calculate fields base on value of other fields - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Calculate fields base on value of other fields

Last post 04-13-2022 07:44 AM by Hilary Stoupa. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 04-12-2022 03:10 AM

    Calculate fields base on value of other fields

    Sample_timesheet.xsn
    Reply Contact
    Dear Support team, Could you please help me this issue: - I have timesheet form with Timein & Timeout - Working day is from Monday - Saturday, Sunday is off. Working hours is 8h/day ( 12-13h is lunch time) - With Saturday, working hours from 8:30 AM - 12:30 PM = 4 Hours My issue: Ex: in Saturday, if staff working more than 4 hours, can it calculate the rest hours to OT Ex: 8:30AM - 15:30 PM = 6 hours, I want it devices Total Hours = 4h and OT = 2. I attached my Form in this post. Appreciate for your help. Regards, Hai Nguyen

  • 04-13-2022 07:34 AM In reply to

    Re: Calculate fields base on value of other fields

    Mark as Answer
    Reply Contact
    My initial reply was that you should DateDiff if you were using FormsViewer - I now see that you are just subtracting one time from the other. So - on your working hours field, you could add rules to set the total and OT based on the date. I'll modify your sample here shortly & attach.
    Hilary Stoupa

  • 04-13-2022 07:44 AM In reply to

    Re: Calculate fields base on value of other fields

    Sample_timesheet.xsn
    Mark as Answer
    Reply Contact
    See attached - rule is on field80
    Hilary Stoupa
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.