I have calculated the time it takes to travel from point A to point B. The results are in number of seconds. I have converted the number of seconds to Hours, Minutes, and Seconds in three cells. I want to combine the three cells and use the result in a time calculation to calculate arrival time based on a given start time.

`CONCATENATE`

produces a result that appears correct but can not be used in a time calculation.

```
=CONCATENATE((RIGHT(CONCATENATE("00",I46),3)),":",(RIGHT(CONCATENATE("0",J46),2)),":",(RIGHT(CONCATENATE("0",K46),2)))
```

`TIMEVALUE`

also produces a result but it does not allow for values > 24 hours.

```
=TIMEVALUE(I46&":"&J46&":"&K46)
```

Do you have a solution that will allow me to calculate the arrival time?