This repository contains Visual Basic for Applications (VBA) scripts developed to track and record times in Excel spreadsheets. The scripts allow for starting a cyclic timer, logging activity changes, calculating elapsed times, and generating performance reports based on collected data.
Features Start Cyclic Timer: Function to initiate a timer that records elapsed time across different activities.
Log Activity Changes: Allows updating and logging time spent on changing activities in specific worksheets.
Calculate Elapsed Times: Uses logged data to compute total durations for each activity and generate detailed reports.
Clear Time Records: Function to clean and reset time records stored in worksheets.
Instructions:
Download the TimeTrackingVBA.xlsm file and open it in Excel. Enable macros if prompted. Execute VBA procedures as needed to start, stop, or view time records. Example Usage:
Start the cyclic timer using IniciarTemporizadorCICLICO(). Log activity changes with CambioDeActividadCiclico(). Calculate and view elapsed times using ObtenerTiempos(). Clear time records with EliminarTiempos(). Contribution If you'd like to contribute to this project, follow these steps:
Fork the repository. Make your changes in a new branch. Submit a pull request with a clear description of your changes and proposed improvements. License This project is licensed under the MIT License. See the LICENSE file for details.
For any questions or comments, feel free to reach out through my GitHub profile or via email at rafael.moreno.espinoza10@gmail.com.