How can I calculate total hours based on Date/Time fields?

To calculate the number of hours based on the difference between two Date fields:

  1. Add two Date fields to your form, labelled “Start Date” and “End Date”.
  2. Add two Time fields to your form, labelled “Start Time” and “End Time”.
  3. Add a Calculation field labelled Total Hours, and insert the following expression: =(Math.Round((EndDate.AddMinutes(EndTime.Minute + (EndTime.Hour * 60)) - StartDate.AddMinutes(StartTime.Minute + (StartTime.Hour * 60))).TotalMinutes / 15) / 4)
  4. Now, when the user inputs their start and end times, the Calculation field will automatically display the total number of hours in 15 minute increments:

Form for calculating total hours, with fields for "Start Date," "End Date," "Start Time," and "End Time," calculating "Total Hours." The example shows 31.25 total hours.

Learn more about Date/Time calculations.