The closest I can find to my question is this Summing Hours as duration not correct but it is not quite the same, and the solution does not work for me.
I want to sum a column of time durations. A time duration is not the same as a time, even if it looks similar and obeys some of the same rules. It seems to me there should be separate format for durations. Using the time format like
[HH]:MM:SS it gives me a result like -00:21:18 even though none of my value are negative.
(I tried omitting the hours entirely, as I have values in minutes and seconds and don’t care about converting up to hours, but could not get it to even interpret a number like 13:38 correctly).
Is there any way to do this?