Spreadsheets articles

Spreadsheets are where most of us do our data analysis on. For that reason, we have many formulas and tools to aid us...

Various spreadsheets programs that we have been using have one main goal. To help us understand the underlying data....

While the first parameter accepts only range references, the second parameter can take both direct numbers as well as...

The TIME formula in Google Sheets accepts a given time through the hour, minute, and second component values, and...

In our day to day lives, we will be needing to do certain activities that may be time-sensitive. There can be business...

At times we may need to pick the hour from a time value. Possibly to use it with another formula that calculates an...

Let’s say we need to know how far two different dates are separated from each other, based on the 360 day year....

Almost all of us at some point in our lives may opt for loans, against a prevailing interest rate. And we’d be...