Formula to calculate time and duration

Brian Dollen Is there a way to create a formula for what would be similar to a Drive/Travel Time Calculator?

  • We would set up the following fields:

    • Input Fields (yellow highlights in image below)

      • Distance (in miles)

      • Average Speed (mph)

      • Time of Breaks (minutes and/or hours)

      • Departure Time (date and time)

    • Result Fields (green highlights in image below)

      • Total Drive Time (hours and minutes)

      • Arrival Time (date and time)

2
19 replies