Google Sheets
Google Sheets: Remove Non-Numeric Characters from Cell
You can use the following formula to remove non-numeric characters from cells in Google Sheets:
=REGEXREPLACE(A2,"D+", "")
This particular formula will remove all non-numeric characters from...
Google Sheets
Google Sheets: How to Convert Time Duration to Minutes
You can use the following formula to convert a time duration to minutes in Google Sheets:
=VALUE(B2*24*60)
This particular formula converts the time duration in cell...
Google Sheets
Google Sheets: How to Convert Time Duration to Seconds
You can use the following formula to convert a time duration to seconds in Google Sheets:
=VALUE(B2*24*3600)
This particular formula converts the time duration in cell...
Google Sheets
How to Calculate Day of the Year in Google Sheets
You can use the following formulas to calculate the day of the year in Google Sheets:
Formula 1: Calculate Day of the Year for Today
=TODAY()-DATE(YEAR(TODAY()),1,0)
This...
Google Sheets
How to Use Count Unique IF Function in Google Sheets
You can use the following methods to count unique values based on criteria in Google Sheets:
Method 1: Count Unique Values Based on One Criteria
=COUNTUNIQUEIFS(A2:A10,...
Google Sheets
Google Sheets: Quickly Convert Time to Decimal
You can use the following formula to convert a time to a decimal in Google Sheets:
=HOUR(B2)+(MINUTE(B2)/60) + (SECOND(B2)/3600)
This particular formula converts the time in...
Google Sheets
Google Sheets: Use “Not Equal” in Conditional Formatting
You can use the custom formula function in Google Sheets to apply conditional formatting to cells that are not equal to a specific value.
The...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read