I would like to get a column with the difference between H and G. So I would be filled with -02:30.
The formula =H2-G2 will work fine in Google Sheets once you format as Duration by going to
Format - Number - Duration
Please use the following
(adjust the range to your needs and format as date)
How the formula works:
Because REGEXREPLACE takes only text values we use TEXT to turn the numbers to text, edit them and then turn them ...