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.
User | Count |
---|---|
41 | |
36 | |
29 | |
23 | |
16 |