6 Replies Latest reply on May 14, 2017 11:49 AM by gkaiseril

    calculate total hours between two date fields and two time fields

    eugzl Level 1

      Hi All.

       

      In my PDF form I would like to calculate total hours between two date fields StartDate and EndDate which formatted like m/d/yyyy. And two time fields StartTime and EndTime which formatted like HH:MM. If StartDate and EndDate are the same so total hours between = 0. If startDate and EndDate are different (5/10/2017 and 5/11/2017) so Total = 7.

      For instance:

      StartDateEndDateStartTime
      EndTimeTotal
      5/10/20175/10/201709:0013:004:00
      5/10/20175/11/201709:0015:3012:30

      How to solve that problem?

       

      Thanks.