How to Use the MINUS Function in Google Sheets
Learn how to use MINUS in Google Sheets to subtract two cells, fill a column with ARRAYFORMULA, work with dates and times, and fix #VALUE! and sign errors.
How to subtract in Google Sheets on the web and on mobile.
Learn how to use MINUS in Google Sheets to subtract two cells, fill a column with ARRAYFORMULA, work with dates and times, and fix #VALUE! and sign errors.
Subtract time in Google Sheets with =B2-A2 and Duration format, fix overnight shifts with MOD, take hours off a time, and convert results to decimal hours.
Subtract in Google Sheets with =A2-B2, the MINUS function, SUM for long lists and ARRAYFORMULA for columns, plus fixes for #VALUE!, wrong signs and formats.
Subtract dates in Google Sheets with =B2-A2, DAYS, DATEDIF or NETWORKDAYS to get days, months, years or workdays, plus fixes for 1900 dates and #VALUE! errors.