Trying to make a duration

[Luke_Vancleave]

Hi, I’m to calculate a duration based on two things that are not durations. I have one column that is a number of “miles remaining” and another that is “my average moving speed”. So I’m dividing the first by the latter to see how many hours I need to travel. But I get a result that is a number and I need to convert it to a duration of hours for the other columns to calculate. Any advice?

[Marc_Dillon]

A Duration value can be made by generating a text string of the form “hhh:mm:ss”.

help.appsheet.com

Date and Time Expressions

Incorporate dates and times into the behavior of your app.

help.appsheet.com

CONCATENATE()

Merged text from parts

[Luke_Vancleave]

Okay, thanks! I’m working on ways to make that work out. It’s difficult because it’s going to involve rounding and quite a bit of concatenating. Maybe this is a feature request for something like DurationHour(), DurationMinute(), DurationSecond(), that would take a number as an input parameter and spit out a duration of hours, minutes, or seconds based on that? So like…
DurationHour(55.5) would come out 055:30:00.

[Marc_Dillon]

Luke_Vancleave:

Maybe this is a feature request for something like DurationHour(), DurationMinute(), DurationSecond(), that would take a number as an input parameter and spit out a duration of hours, minutes, or seconds based on that? So like…
DurationHour(55.5) would come out 055:30:00.

I think that would be a good idea.

[MultiTech]

Luke_Vancleave:

But I get a result that is a number and I need to convert it to a duration of hours for the other columns to calculate. Any advice?

Here ya go!

Convert (Distance ÷ Speed) into Duration Tips & Tricks 💡

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-Di…