Velocity Unit Converter in Excel

From To

0.04166666667

Add-in Formula =PO.UnitConverter(1, "ft/d", "ft/h")

Excel Lambda

=LAMBDA(x,
  LET(
    ratio, 0.0416666666666667,
    x * ratio
  )
)(1)

Category Lambda

=LAMBDA(x, from, to,
  LET(
    f, SWITCH(from,
      "m/s", 1,
      "m/h", 0.000277777777777778,
      "m/d", 1.15740740740741E-05,
      "ft/s", 0.3048,
      "ft/h", 8.46666666666667E-05,
      "ft/d", 3.52777777777778E-06,
      "km/h", 0.277777777777778,
      "mi/h", 0.44704,
      "knot", 0.514444444444444),
    t, SWITCH(to,
      "m/s", 1,
      "m/h", 0.000277777777777778,
      "m/d", 1.15740740740741E-05,
      "ft/s", 0.3048,
      "ft/h", 8.46666666666667E-05,
      "ft/d", 3.52777777777778E-06,
      "km/h", 0.277777777777778,
      "mi/h", 0.44704,
      "knot", 0.514444444444444),
    x * f / t
  )
)(1, "ft/d", "ft/h")

How to save as a reusable Excel function

LAMBDA is a built-in Excel feature (Microsoft 365) that lets you create custom functions without VBA. The formulas above work as-is when pasted into a cell.

To save a LAMBDA as a reusable named function:

Go to Formulas → Name Manager → New
Enter a name, e.g. ConvertVelocity
In Refers to, paste the LAMBDA formula without the trailing invocation (...)
Click OK

Now use =ConvertVelocity(1, "ft/d", "ft/h") anywhere in your workbook — no add-in required.

Conversion Factors (base: m/s)

Unit	Name	Factor
m/s	metre per second	1
m/h	metre per hour	0.000277777777777778
m/d	metre per day	1.15740740740741E-05
ft/s	foot per second	0.3048
ft/h	foot per hour	8.46666666666667E-05
ft/d	foot per day	3.52777777777778E-06
km/h	kilometre per hour	0.277777777777778
mi/h	mile per hour	0.44704
knot	knot	0.514444444444444