Welcome to the forum.

Does this have to work in Excel 2019 or exclusively for 365? Your forum profile should show the version any solutions will need to work for.

It might need VBA, but what is certain is that you will need to provide some parameters for the randomisation: range for start and end times and min/max Pausezeit.