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.
TIMEVALUE also produces a result but it does not allow for values > 24 hours.
Do you have a solution that will allow me to calculate the arrival time?