# Google sheets formula for average velocity

In this post we’ll look at how to calculate a running total, using a standard method and an array formula method. We’ll cover the topic of matrix multiplication (take a deep breath, it’s going to be ok!) using the MMULT formula, one of the more exotic, and challenging formulas in Google Sheets.

Today we’re going to geek out in a spreadsheet because I was talking with some friends over at the Motley Fool and mentioned I use a Google spreadsheet to track my stock portfolio. Here’s an example of what the spreadsheet looks like, and you can scroll to the bottom to download a copy. In this post we’ll look at how to calculate a running total, using a standard method and an array formula method. We’ll cover the topic of matrix multiplication (take a deep breath, it’s going to be ok!) using the MMULT formula, one of the more exotic, and challenging formulas in Google Sheets.

When the number being returned by your formula is being formatted as a time, and you want it formatted as a plain number, change the format of the cell to a plain number format: click the cell and then click Format, Number, Normal. Time values in Google spreadsheet are represented as days and parts of days. Google allows users to search the Web for images, news, products, video, and other content. I've done a lot of experimentation. This is the easiest way to calculate a time delta in Google Spreadsheets. Format the cell containing the formula like this: Format > Number > More Formats > More date and time formats, delete "second" and :.