Question
calculate total hours between two date fields and two time fields
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:
| StartDate | EndDate | StartTime | EndTime | Total |
|---|---|---|---|---|
| 5/10/2017 | 5/10/2017 | 09:00 | 13:00 | 4:00 |
| 5/10/2017 | 5/11/2017 | 09:00 | 15:30 | 12:30 |
How to solve that problem?
Thanks.
AdChoices