New answers tagged

0

You mention 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


0

Please use the following =ArrayFormula(IF(A2:A="",, REGEXREPLACE(TEXT(A2:A,"#"),"(\d{4})(\d{2})(\d{2})","$1/$2/$3")^1)) (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 ...


Top 50 recent answers are included