Convert (Distance ÷ Speed) into Duration

concatenate(
  right("000" & floor([Time_Remaining]), 3), 
  ":",
  right("00" & number(([Time_Remaining] - floor([Time_Remaining])) * 60), 2), 
  ":00"
)

If you take two numbers (miles) and (miles per hour) and divide those two, it will give you a decimal.

  • i.e. 15 miles ÷ 10 mph = 1.5

To convert that decimal result into a duration, it requires a little slicing/and/dicing of the decimal.

Here is a sample app that demonstrates what this looks like

https://www.appsheet.com/samples/Convert-Distance--Speed--Duration?appGuidString=cad7e456-6870-474f-b679-b424784452b0

4 Likes