ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calculating the total time of an excel logfile (https://www.excelbanter.com/excel-programming/427642-calculating-total-time-excel-logfile.html)

tom

Calculating the total time of an excel logfile
 
I have a process log file that records every minute over a continuous 50 to
65 hour time frame each time the process it run. I would like to be able to
create a macro that can calculate the total time of the process run and also
allow the selection of the start cell and end cell . The time is recorded in
HH:MM:SS and is in one column of the log file spreadsheet. I can provide an
example of a portion of the log file that contains the time section.
Thanks



All times are GMT +1. The time now is 07:43 PM.

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