I don’t know if this is new but we have a “Duration” column type now.
Those are 2 normal columns in Sheet, I just formatted them one as number, one as duration.
However I might do this differently though. Check this thread for some inspiration.