New answers tagged date
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
