Elapsed times

Original by Reinie, 2017

This summary note was posted on 2 March 2017, by Reinie in Excel #VBA

Get execution time of your code and display it in the status bar.

Dim tic, toc, boom As Double

tic = Now  ' time start

[ Your loop/code here ]

toc = Now  ' end time
boom = tic - toc ' in seconds
Application.StatusBar = " Elapsed Time: " & Format(boom, "hh:mm:ss") & _
" ("  & Format(boom * 86400, "0.00")  & " seconds

Related Hamster Notes

Quick value reading from closed workbook Excel #VBA

Latest Hamster Notes

Start with Why posted in Management #innovation, #Why
4 steps to optimise product value posted in Agile Management #agile, #product, #Scrum, #value
5 paradoxes of digital business leadership posted in Agile #agile, #leadership, #value
Product Vision, 10 tips posted in Agile #agile, #product, #Scrum
Progress in adopting the Principles for effective risk data aggregation and risk reporting 2023 posted in Credit risk Finance #BIS, #data, #reporting
Leadership styles by ChatGPT posted in Management #ChatGPT, #leadership, #style
Gen AI round table posted in Machine Learning #ChatGPT, #Copilot, #Gen AI, #Github
Leadership in fully remote teams posted in Management #leader, #leadership, #remote, #thatconference19
Leadership for the reluctant leader posted in Management #leader, #leadership, #thatconference19
Corporate Credit Risk Modelling and the Macroeconomy posted in Finance #corporate, #duration, #macroeconomy