ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   measure calculation time for multiplication of two matrices (https://www.excelbanter.com/excel-worksheet-functions/115901-measure-calculation-time-multiplication-two-matrices.html)

Rasoul Khoshravan

measure calculation time for multiplication of two matrices
 
I want to multiply two big matrices using mmult function.
The size of both matrices are 256*256. Each one is stored in a single sheet.
REsult will be stored in the third sheet.
I am wondering how much time it will take.
In the mean time I would to measure the time necessary for this
multiplication.
What is the best way to measure the calculation time? Is there any command
in Excel which can measure calculation time?



All times are GMT +1. The time now is 04:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com