Examples and discussion of VBA code that maybe of use
Following an enquiry about how to pause running code in Excel I thought I would put together a quick blog post to demonstrate the mechanisms we can do this in Excel, Python and C++
The code is simple, is fully listed along with descriptions and a video demonstration for writing your own in VBA.
This post and video talk about traffic to the blog and further examples of how to convert the current time into a number representing how many half-hour periods have elapsed during the day using both VBA and Python. These calculations are often involved in the UK Power market.
Video and full source code are provided
A run through on how to use Excel and VBA to convert the date/time into the half hour period for use in UK power analysis. Video and source code all provided
