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?
A Duration value can be made by generating a text string of the form “hhh:mm:ss”.
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.
I think that would be a good idea.