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
Related Tags
date × 64google-sheets × 50
formulas × 11
google-apps-script × 8
formatting × 7
google-sheets-dates × 7
conditional-formatting × 6
cognito-forms × 2
google-search × 2
sorting × 2
google-sheets-timestamp × 2
microsoft-excel × 2
gmail × 1
trello × 1
google-apps × 1
google-docs × 1
google-calendar × 1
google-sheets-query × 1
google-forms × 1
outlook.com × 1
search × 1
blogger × 1
keyboard-shortcuts × 1
tumblr × 1
google-sheets-charts × 1