how to change the time format?

@rolandnemeth this is an interesting approach but you have to be aware that you do not have a duration, but a (local) time variable. That might have implications further down the line; and you will not be able to do calculations and the solution would only work for durations up to 24h.

What one could do would be to change the format into something like this:

Or indeed extract the duration fields and then put them together as a string. They could be later split into parts and be converted to a duration field again.

2 Likes